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 |
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 |
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 |
All times are GMT +1. The time now is 05:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com