Date Calculations and auto-update

JayTeeDee

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.

Paul Newcome

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)

Paul Newcome

How are you currently populating the Target Closure Date?

JayTeeDee

@Paul Newcome manual date field.

Paul Newcome

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.

JayTeeDee

@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.

Paul Newcome

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)

JayTeeDee

Thank you @Paul Newcome

Paul Newcome

Happy to help. 👍️