Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like:
=FirstWorkDate(Today(), 2 , <holiday list>)