Date Calculations and auto-update
Would like to have a formula where if the 'Extension Closure Date' is = or after the 'Target Closure Date', then the 'Target Closure Date' will automatically update to the 'Extension Closure Date', if not, then the 'Target Closure Date' will stay the same. Thank you.
Best Answer
-
Yes. That would be exactly what I mean by the first bit regarding a separate column.
The easiest formula to evaluate both and pull the appropriate would be a basic MAX function.
=MAX([Extension Closure Date]@row, [Target Closure Date]@row)
Answers
-
How are you currently populating the Target Closure Date?
-
@Paul Newcome manual date field.
-
Then you would either need a separate column to house a formula to pull one or the other, or you would have to continue with manual entry. You cannot have both manual entry and a working formula in the same cell because manual entry will override/delete the formula.
-
@Paul Newcome Then what if we have a new column "New Date" where if the 'Extension Closure Date' is equal to or after the 'Target Closure Date', then the 'New Date' will populate with the 'Extension Closure Date', if not, then the 'Target Closure Date' will populate the 'New Date' column. If there's no dates, then the "New Date" column will remain blank instead of an error. Thank you.
-
Yes. That would be exactly what I mean by the first bit regarding a separate column.
The easiest formula to evaluate both and pull the appropriate would be a basic MAX function.
=MAX([Extension Closure Date]@row, [Target Closure Date]@row)
-
Thank you @Paul Newcome
-
Help Article Resources
Categories
Check out the Formula Handbook template!
