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
- Date formula in excel dd/mm/yyyy - Guide
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Start survey - Download - Horror
- Logitech formula vibration feedback wheel driver - Download - Drivers
1 response
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