Date Calculations
 

How do you have Excel calculate the difference between business? For example
if a customer call on Oct 1, 2009 and you want to followup up 5 business days
later, what would be the calculations? I know how to do regular days but not
how to drop Saturdays and Sundays.
--
Rose

Date Calculations
 

Try
NETWORKDAYS



"Rose" wrote:

How do you have Excel calculate the difference between business? For example
if a customer call on Oct 1, 2009 and you want to followup up 5 business days
later, what would be the calculations? I know how to do regular days but not
how to drop Saturdays and Sundays.
--
Rose

Date Calculations
 

It's not clear what you want.

If you want to know the future date after adding 5 business days to a date
try this:

A1 = Oct 1, 2009

=WORKDAY(A1,5)

Format as Date

Note that the WOKDAY function requires the Analysis ToolPak add-in be
installed on versions of Excel prior to Excel 2007.

--
Biff
Microsoft Excel MVP


"Rose" wrote in message
...
How do you have Excel calculate the difference between business? For
example
if a customer call on Oct 1, 2009 and you want to followup up 5 business
days
later, what would be the calculations? I know how to do regular days but
not
how to drop Saturdays and Sundays.
--
Rose