Forum Discussion
Solved
Help calculating a date, excluding weekends and US holidays
I am doing a project workback schedule in excel. I need a formula to calculate the End Date, minus the duration, excluding weekends and holidays. A = Duration B = Start Date C = End Date My for...
Since your references change in every posting I will use placeholders. You fill in the real references.
=WORKDAY(Due_Date,-Duration,Holidays)Holidays refers to a range with US holiday dates.
TY for the reply 🙂 This is just for US. I've tried ..... =WORKDAY(C1-A1)[holidays] but it doesn't work? What am I doing wrong?
