Excel formula which calculates start date
Closed
lsolomon
ExcelJosh
- Posts
- 1
- Registration date
- Friday August 31, 2012
- Status
- Member
- Last seen
- August 31, 2012
ExcelJosh
- Posts
- 12
- Registration date
- Wednesday August 8, 2012
- Status
- Contributor
- Last seen
- October 12, 2012
Related:
- Excel formula which calculates start date
- Excel – Formula to calculate between two columns - How-To - Excel
- Excel formula to calculate 90 days from a specific date - Guide
- Excel formula to calculate vat - Guide
- Formula for calculating position in excel ✓ - Forum - Office Software
- Calculation of positions in excel ✓ - Forum - Excel
1 reply
ExcelJosh
Sep 5, 2012 at 09:02 AM
- Posts
- 12
- Registration date
- Wednesday August 8, 2012
- Status
- Contributor
- Last seen
- October 12, 2012
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