Hello,

I have several reports that I need to send to several people on certain days of the month. So to avoid the last minute preparation, I prepare the report on previous working date. Below code helps me to get those date in the attachment for each report.

=WORKDAY(DATE($C$2,E$2,2), -1,$B$27:$B$48)


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.

I am not able to combine my both criteria in single cell. Did Vlook up as well, but all fails.

Attached sheet for your reference. Someone please assist me here.

Thanks,
Shiva