View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove
 
Posts: n/a
Default How do you calculate workdays if Saturday is a workday?

Tracy Parish wrote...
I need to calculate the amount of business days from a start date including
Saturday as a business day. Example: 5 business days starting Wednesday. In
WORKDAY it would be the next Wednesday, in Date plus 5 it would be the
following Monday. The correct answer is Tuesday.


If you mean you have 5 workdays, Tuesday through Saturday, just
subtract 1 from beginning and ending dates and use NETWORKDAYS (in the
Analysis ToolPak).

If you mean you have 6 workdays each week, count the number of days
that aren't Sundays.

=SUMPRODUCT(--(WEEKDAY(ROW(INDEX($1:$65536,B,1):INDEX($1:$65536, E,1)))<1))

where B represents the beginning date and E the ending date.