| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date going forward
I have a user who would like to calculate a date going 60 working days
forward from a date in her spreadsheet. One column contains the date of an incident and she needs a date 60 working days ahead when the report of the incident is due. Only working days, not total days. She currently counts the days manually. Anyone have a solution for her? -- Donna |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date going forward
=WORKDAY(A1,60)
Format cells as date "Donna" wrote: I have a user who would like to calculate a date going 60 working days forward from a date in her spreadsheet. One column contains the date of an incident and she needs a date 60 working days ahead when the report of the incident is due. Only working days, not total days. She currently counts the days manually. Anyone have a solution for her? -- Donna |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date going forward
=WORKDAY(A1,60)
-- David Biddulph "Donna" wrote in message ... I have a user who would like to calculate a date going 60 working days forward from a date in her spreadsheet. One column contains the date of an incident and she needs a date 60 working days ahead when the report of the incident is due. Only working days, not total days. She currently counts the days manually. Anyone have a solution for her? -- Donna |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I GET A BALANCE TO C/FORWARD TO NEXT WORKSHEET | Excel Worksheet Functions | |||
| hyphen to forward slashes? | Excel Discussion (Misc queries) | |||
| Auto calculate for date + days forward to yield new date | Excel Worksheet Functions | |||
| Carrying a balance forward | Excel Worksheet Functions | |||
| Page forward goes backwards | Excel Discussion (Misc queries) | |||
Linear Mode
