network days

[uk747]

I have a formula to calculate the number of network days between 2 dates and including exception dates=NETWORKDAYS(A2,A1,B1:B4), however what I need is to put a date in cell C1 and D1 will calculate 28 network days (c1) after including any days that are in B1:B4 and 99 days(d1)

 

[Jonmo1]

The WORKDAY function is what you're looking for.

NETWORKDAYS = Number of days between 2 given dates
WORKDAY = A Date that is x number of days before/after the given date.

=WORKDAY(C1,28,B1:B4)

Although I'm not sure I follow what you mean by "and 99 days(d1)"

 

[uk747]

The WORKDAY function is what you're looking for.NETWORKDAYS = Number of days between 2 given datesWORKDAY = A Date that is x number of days before/after the given date.=WORKDAY(C1,28,B1:B4)Although I'm not sure I follow what you mean by "and 99 days(d1)"

Thanks, the 99 days was just 99 days after in cell D1 so if A1=today() then would be =workday(A1,99,B1:B4)

 

[Jonmo1]

OK, sorry. I thought that's what the 28 was...

 

[uk747]

no problem I didnt explain properly, the 28 was 28 days after in C1 and 99 days after in D1Thanks for your help, never heard of the workday formula and was exactly what I wanted

 

[Jonmo1]

Glad to help. Thanks for the feedback.