| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF AND calculations with date | Excel Worksheet Functions | |||
| Help with Date calculations | Excel Worksheet Functions | |||
| Date Calculations | Excel Worksheet Functions | |||
| Date Calculations before date entered | Excel Discussion (Misc queries) | |||
| Date calculations | Excel Discussion (Misc queries) | |||
Linear Mode
