Calculation of Dynamic Previous Day

arvindjha2050 — Mon, 20 Dec 2021 21:38:40 GMT

Hello Team,

I need to calculate dynamic previous day based on below logic :

For Tuesday to Friday it will be previous day.

For Monday it will be Friday.But if Friday is Holiday it should be Thursday.

How to accomplish that?

Thanks

Re: Calculation of Dynamic Previous Day

tresB — Mon, 08 Jul 2019 06:57:17 GMT

Try like:

=FirstWorkDate(Today(), 2 , <holiday list>)