Function to calculate Date like WORKDAY() but backward

[chamdan]

Did anyone created a Function that calculate date backward and takes into consideration weekends and Holidays the way WORKDAY() function would.

The goal is to obtain a date based on a End Date and a number of days back in time and taking into consideration weekends (Such as Saturday and Sunday non working days) as well as Holidays and therefore the researched date would equal the number of days + any non working days and any holidays.

The resulted date should give us the same ending date when applying the Workday(Start_day,days,Holidays).

Looking forward to hearing from any one out there.

Your help will be much appreciated.

Note: this function will resolve my trouble when applying the "SS", "FS" and "FF" when creating a Gantt chart.

Thank you in advance!

 

[shg]

Days can be negative in the WORKDAY function.

 

[chamdan]

Thank you for your prompt reply! Do you mean that the number of days to be input can be negative? e.g. (-3) for instance? if so, then you saved me.

 

[shg]

You tried it, and ...

 

[chamdan]

Works well thank you!