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" wrote:

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

"Kurt Levitan" wrote in message
...
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