Date Calculations

R

Rose

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.
 
T

T. Valko

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating dates to include Saturdays but not Sundays 1
Counting Days of Week 2
Excel not responding before calculations 1
Calculate Payment Days and Date 7
How do I calculate future date after number of days 1
Non working days 4
MS Project. Real progress of the project, % complete 1
Counting calendar Days - not including Sundays 3

Top