Jul 28 2022 05:27 PM
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
Jul 28 2022 05:41 PM
Jul 28 2022 05:44 PM
Jul 28 2022 05:53 PM
Jul 28 2022 05:58 PM
@mtarler Here is my excel document that I'm trying to exclude weekends and US holidays from.
TYSM! Nora
Jul 28 2022 06:31 PM
SolutionSince 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.
Jul 28 2022 06:55 PM
Jul 28 2022 06:31 PM
SolutionSince 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.