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 formula is =C1-A1=B1
C1 = 8/19/22
B1 = ?
A1 = Duration
Question: How do I exclude weekends and holidays from this formula?
Thank you in advance, Nora from Southern California
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?
- 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.
