Networkdays plus Sundays

[Guest]

Hi,
I need to calculate the number of work days between two dates that
includes Sundays as a workday. So only Saturday would be excluded. Is there
a way to count the number of Sundays between two dates? I could then just
add that to the result of the NetWorkDays function.

Thanks!
- Kurt

 

[Guest]

I would use a combination of the following:

First step = end_date minus start_date divided by 7 and take only the
integer part.

Second step = using the WEEKDAY function to identify if another extra Sunday
needs to be added or not?

Best of luck.

 

[Guest]

I would use a combination of the following:

First step = end_date minus start_date divided by 7 and take only the
integer part.

Second step = using the WEEKDAY function to identify if another extra Sunday
needs to be added or not?

Best of luck.

 

[Biff]

If you DON'T need to account for any holidays:

F1 = start date
G1 = end date

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(F1&":"&G1)))<>7))

If you DO need to account for holidays:

List of holiday dates to be excluded from the calculation in I1:I10

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(F1&":"&G1)))<>7))-SUMPRODUCT(--(ISNUMBER(MATCH(ROW(INDIRECT(F1&":"&G1)),I1:I10,0))))

Biff

 

[Biff]

If you DON'T need to account for any holidays:

F1 = start date
G1 = end date

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(F1&":"&G1)))<>7))

If you DO need to account for holidays:

List of holiday dates to be excluded from the calculation in I1:I10

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(F1&":"&G1)))<>7))-SUMPRODUCT(--(ISNUMBER(MATCH(ROW(INDIRECT(F1&":"&G1)),I1:I10,0))))

Biff

 

[Guest]

Thanks Biff,
You actually provided me with a simpler answer in another post for
somneone else. I can use the Network Days to get the week days minus
holidays and then use : SUM(INT((WEEKDAY(A1-7,2)+B1-A1)/7)) to add back in
the Sundays.

- Kurt

 

[Guest]

Thanks Biff,
You actually provided me with a simpler answer in another post for
somneone else. I can use the Network Days to get the week days minus
holidays and then use : SUM(INT((WEEKDAY(A1-7,2)+B1-A1)/7)) to add back in
the Sundays.

- Kurt

 

[Biff]

I was going to suggest that but I thought what I did suggest is a little
easier to understand and maintain if the need arises.

Thanks for the feedback!

Biff

 

[Biff]

I was going to suggest that but I thought what I did suggest is a little
easier to understand and maintain if the need arises.

Thanks for the feedback!

Biff