| 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? |
| 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) | |||
Threaded Mode
