How To Convert Working Days To Calendar Days. @alexkangaroo, you can get the calendar end date by adding the lead time (simple date addition since excel dates are in units of days). Make quick calculations and find the working days count days
You can also derive the. I need to convert business days to calendar days.
The Solution To This Problem Involves Two Steps.
In excel 2010 and higher, more powerful.
Calculate A Calendar Date Given How Many Days Or Business Days Into The Future Or The Past.
You can also derive the.
Using Sum &Amp; Weekday Functions.
Images References :
I Was Given This Formula From Someone On This Form A.
You can also derive the.
In The For Calendar List, Select The (Project Calendar) You'd Like To Edit.
I would appreciate any suggestions on the following as i am truly stuck.