Forum Discussion
Calculate a past date based on future date
Hello, I need to be able to calculate a past date based on a given date excluding weekends and holidays. For example a package will be delivered on October 5th but for that to happen it needs to be...
Unless I'm mistaken you could use the Excel function WORKDAY to calculate the day 5 days prior to a given date.
I entered 10/5/22 into cell C3 (see the image below) and then this formula =WORKDAY(C3,-5) which yielded 9/28/22 as the answer.
The link above will take you to a site where you can learn more, including how to incorporate holidays into the calculation;
