software

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.

Tracy Parish wrote...
gt;I need to calculate the amount of business days from a start date including
gt;Saturday as a business day. Example: 5 business days starting Wednesday. In
gt;WORKDAY it would be the next Wednesday, in Date plus 5 it would be the
gt;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)))lt;gt;1))

where B represents the beginning date and E the ending date.
If you have a date in A1 and a number of workdays to add in B1...

=INT(B1/6)*7 A1 MOD(B1,6) INT((WEEKDAY(INT(B1/6)*7 A1)-2 MOD(B1,6))/6)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=530347Dear daddylonglegs,

Two years later, your formula remains useful. Thanks a lot.

P.B.Mohan

quot;daddylonglegsquot; wrote:

gt;
gt; If you have a date in A1 and a number of workdays to add in B1...
gt;
gt; =INT(B1/6)*7 A1 MOD(B1,6) INT((WEEKDAY(INT(B1/6)*7 A1)-2 MOD(B1,6))/6)
gt;
gt;
gt; --
gt; daddylonglegs
gt; ------------------------------------------------------------------------
gt; daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
gt; View this thread: www.excelforum.com/showthread...hreadid=530347
gt;
gt;