WORKDAY byt with saterday included

[DanWo]

I would like to calculate End Date from Start Date + Duration in day excluding holidays.

For this Workday function is OK, but if I want to include saterdays as Working Day (excluding when saterdays are holiday , of course)?

 

[SkipVought]

Hi,

Try NETWORKDAYS

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[bluedragon2]

Didn't do a lot of testing on this, but looks like it may work. You will have to reference holidays in the NETWORKDAYS formula and it will not take into account for Saturday holidays, so it is probably useless to you, but here it is anyway

=IF(WEEKDAY(A1)=7,NETWORKDAYS(A1,B1)+INT((B1-A1)/7)+1,NETWORKDAYS(A1,B1)+INT((B1-A1)/7))

A1 is start
B1 is end



Blue

If I wasn't Blue, I would just be a Dragon...

 

[DanWo]

Ok for the formula to calculate the number of days, but, what I want to do is to calculate End Date if:
A1 = Start Date
B1 = Duration in days

 

[bluedragon2]

ok, didn't have much time to test this one either, but take a look:

I have:

A1 - Start Date
B1 - # of Days
F1:G12 - Holiday Dates in Column F and 1-12 in Column G

Here is the formula I used:

=IF(WEEKDAY(A1+(B1+MOD(B1,6))+VLOOKUP(A1+(B1+MOD(B1,6)),F1:G12,2))=1,A1+(B1+MOD(B1,6))+VLOOKUP(A1+(B1+MOD(B1,6)),F1:G12,2)+1,A1+(B1+MOD(B1,6))+VLOOKUP(A1+(B1+MOD(B1,6)),F1:G12,2))

Maybe that will work for you...



Blue

If I wasn't Blue, I would just be a Dragon...