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.
mtarler Here is my excel document that I'm trying to exclude weekends and US holidays from.
TYSM! Nora
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.