# Function to calculate Date like WORKDAY() but backward

#### chamdan

##### New Member
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.

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

#### shg

##### MrExcel MVP
Days can be negative in the WORKDAY function.

#### chamdan

##### New Member
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

##### MrExcel MVP
You tried it, and ...

#### chamdan

##### New Member
Works well thank you!

Last edited:

Replies
3
Views
733
Replies
1
Views
102
Replies
5
Views
359
Replies
4
Views
532
Replies
2
Views
349

1,191,123
Messages
5,984,780
Members
439,910
Latest member
Flyingjoblo

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back