Hi,

Am Tue, 31 May 2016 16:08:00 +0100 schrieb shiva_reshs:

I am facing a challenge when date falls on Weekends or Holiday. In such
cases, I need to prepare the report 2 days prior so I can send the
report one day prior of Weekend or Holiday.

WORKDAY only calculates with workdays so you don't need to check for
weekends or holidays.
Have a look:
https://onedrive.live.com/redir?resi...=folder%2cxlsm
for "Scheduler"
I changed your formulas to a universal one that you can drag to the
right and down.


Regards
Claus B.
--
Windows10
Office 2016