| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can Excel add working days to a date to result in another date?
For example, I need Excel to take the last day of a quarter (6/30) and add 10
working days resulting in the date of the 10th working day. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can Excel add working days to a date to result in another date?
Use the WORKDAY function. These examples are from the Excel 97 help
entry for WORKDAY: WORKDAY(DATEVALUE("01/03/91"), 5) equals 33248 or 01/10/91 If January 7, 1991 and January 8, 1991 are holidays, then: WORKDAY(DATEVALUE("01/03/91"), 5, {33245, 33246}) equals 33252 or 01/14/91 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding only working days to dates | Excel Discussion (Misc queries) | |||
| How do you add 40 working days to a date | Excel Discussion (Misc queries) | |||
| Excel ignores boot-time regional settings when interpreting a date | Excel Discussion (Misc queries) | |||
| Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
| How do I sort by date (not days, weeks, months) in Excel 2000? | Excel Discussion (Misc queries) | |||
Linear Mode
