Excel formula which calculates start date
Closed
lsolomon
Posts
1
Registration date
Friday August 31, 2012
Status
Member
Last seen
August 31, 2012
-
Aug 31, 2012 at 06:37 PM
ExcelJosh Posts 12 Registration date Wednesday August 8, 2012 Status Contributor Last seen October 12, 2012 - Sep 5, 2012 at 09:02 AM
ExcelJosh Posts 12 Registration date Wednesday August 8, 2012 Status Contributor Last seen October 12, 2012 - Sep 5, 2012 at 09:02 AM
Related:
- Excel formula which calculates start date
- Excel date format dd.mm.yyyy - Guide
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
- Number to words in excel formula - Guide
- How to start a listening party on spotify pc - Guide
- Transfer data from one excel worksheet to another automatically - Guide
1 reply
ExcelJosh
Posts
12
Registration date
Wednesday August 8, 2012
Status
Contributor
Last seen
October 12, 2012
Sep 5, 2012 at 09:02 AM
Sep 5, 2012 at 09:02 AM
Isolomon:
I hope this helps.
=WORKDAY(start_date, -1*(SUM(range)-1))
This doesn't take into account for Holidays. You would have to list the holidays you'd like to exclude.
Good luck,
Josh
I hope this helps.
=WORKDAY(start_date, -1*(SUM(range)-1))
This doesn't take into account for Holidays. You would have to list the holidays you'd like to exclude.
Good luck,
Josh