Networkdays plus Sundays
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.
"Kurt Levitan" wrote:
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
|