View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DKS DKS is offline
external usenet poster
 
Posts: 103
Default 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