SOLVED

# Help calculating a date, excluding weekends and US holidays

Occasional Contributor

# 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

6 Replies

# Re: Help calculating a date, excluding weekends and US holidays

NETWORKDAYS and there is an international version and you can set up any set of holidays you want

# Re: Help calculating a date, excluding weekends and US holidays

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?

# Re: Help calculating a date, excluding weekends and US holidays

@mtarler Here is my excel document that I'm trying to exclude weekends and US holidays from.

TYSM! Nora

best response confirmed by Nora Connors (Occasional Contributor)
Solution

# Re: Help calculating a date, excluding weekends and US holidays

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.