| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add business days to a date field, no weekends?
I'm creating an excel spreadsheet and need to add business days only. If
cell a1 is todays date (3/20/06), how do I make cell b1 equal a1+5 business days, no weekends? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I add business days to a date field, no weekends?
See HELP for the NETWORKDAYS function
-- Kind regards, Niek Otten "Ozzy" wrote in message ... I'm creating an excel spreadsheet and need to add business days only. If cell a1 is todays date (3/20/06), how do I make cell b1 equal a1+5 business days, no weekends? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I add business days to a date field, no weekends?
On Tue, 21 Mar 2006 13:41:28 -0800, Ozzy
wrote: I'm creating an excel spreadsheet and need to add business days only. If cell a1 is todays date (3/20/06), how do I make cell b1 equal a1+5 business days, no weekends? =WORKDAY(A1,5) Check HELP for the WORKDAY function. There is an optional Holidays argument. If you get a NAME error, you need to install the Analysis Tool Pak. This is outlined in the HELP topic for the WORKDAY function. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Have a date chane if it is +/- 2 days from the previous date | Excel Discussion (Misc queries) | |||
| Using a date field in mail merge | Excel Discussion (Misc queries) | |||
| With this business with ONLY 5,- EUR OVER 61,370 EUR in 3 months earn!! | Charts and Charting in Excel | |||
| Generating business days in a calendar month, EXCLUDING holidays | Excel Worksheet Functions | |||
| How would I change a date cell to decrease it by business days? | Excel Discussion (Misc queries) | |||
Linear Mode
