Published on Planning Planet (http://www.planningplanet.com)

Home > Discussion Forum > Schedule date calcs in Excel

Schedule date calcs in Excel

By John Reeves
Created 6 Jan 2022 - 20:14
Submitted by John Reeves on Thu, 2022-01-06 20:14

So to calc a completion date in excel that includes the NTP date itself is @sum((A1+A2)-1) because excel does not count the NTP date in that formula.  With a A1 being the NTP date and A2 being that Calendar Days.  Are there any other, or different formulas you use to quickly calc dates in excel. (I see date off by 1 all the time.)

By logging in, inputting data or deciding to view any further of our pages you agree to be bound by our Forum Rules, our T&C's and also our Privacy Policy
© Planning Planet 2000-2024. Run by Project Controllers for Project Controllers.
Source URL: http://www.planningplanet.com/forums/oracle-primavera-pm6/907909/schedule-date-calcs-excel

Links:
[1] http://www.planningplanet.com/forums/oracle-primavera-pm6