Help calculating a date, excluding weekends and US holidays

[Nora Connors]

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

[#2]

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

[#3]

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?

[#4]

@Nora Connors 

[#5]

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

TYSM! Nora 

[#6 · Accepted solution]

@Nora Connors 

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.

[#7]

@Detlef Lewin