Show date based on other dates
I'm trying to get one cell to show the actual end date of a TSA. We have the initial date agreed, the early term date and the extension. Only 2 of these cells should ever be populated as it can't be extended and ended early.
If the early term date and extension date are blank then I want to show the initial date agreed but if either of them are populated then I want to show the new end date.
I'm not really sure where to start on this as every approach I've tried returns unparseasble.
Help Article Resources
Check out the Formula Handbook template!