Excel formula which calculates start date
Closed
lsolomon
Posts
1
Registration date
Friday 31 August 2012
Status
Member
Last seen
31 August 2012
-
31 Aug 2012 à 18:37
ExcelJosh Posts 12 Registration date Wednesday 8 August 2012 Status Contributor Last seen 12 October 2012 - 5 Sep 2012 à 09:02
ExcelJosh Posts 12 Registration date Wednesday 8 August 2012 Status Contributor Last seen 12 October 2012 - 5 Sep 2012 à 09:02
Related:
- Excel formula which calculates start date
- Vat calculation excel - Guide
- Grade formula in excel marksheet - Guide
- Formula bar in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel formula - Guide
1 response
ExcelJosh
Posts
12
Registration date
Wednesday 8 August 2012
Status
Contributor
Last seen
12 October 2012
5 Sep 2012 à 09:02
5 Sep 2012 à 09:02
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