I need to find the latest date out of the two columns. If the “revised end date” column has a date, than that is the latest date. The “revised end date” could have improved date than “planned end date” or a later date as well. Explained well in the appended image. I need the “date as an output” and not the time. Thanks for your help and guidance.
The rows belong to a particular item and hence they are the ones that need to be compared.
Tried =INT(MAX([@[Planned End Date]],[@[Revised End Date]])) but couldn’t find success.
2
Use IF() to check dates in column C. Try-
=IF(ISNUMBER(C363),C363,B363)