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.
NETWORKDAYS and there is an international version and you can set up any set of holidays you want
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.