Oct 12 2022 05:57 AM
Good Morning!
Need some help figuring out how to have these three columns show the end date of a project, soon as I input the NTP Start Date.
Example: NTP Date 10/01/2022 + Contract Period Date (60 Days) = Contract End Date 11/30/2022
NTP Date | Const. Contract Period (Days) | Contract Period End Date |
10/01/2022 | 60 | 11/30/2022 |
Thank you for any assistance.
Oct 12 2022 06:01 AM
Let's say these are columns A, B and C.
In C2:
=IF(OR(A2="", B2=""), "", A2+B2)
Fill down as far as you want. (If your data are in a table, the formula should be propagated down automatically)
Oct 12 2022 07:31 AM
Oct 12 2022 08:06 AM
Oct 12 2022 08:08 AM
Make sure that Calculation Options on the Formulas tab of the ribbon is set to Automatic.
Also make sure that the formula in J2 is
=IF(OR(H2="", I2=""), "", H2+I2)
without any $ in the formula, and that you have filled or copied it down from J2.
Oct 12 2022 08:23 AM