Calculation of Dynamic Previous Day

[arvindjha2050]

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

[tresesco · Accepted solution]

Try like:

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