Selecting content from one cell over another
Hi not sure where to start with this one
I have a range of cells where the dates may change. in the summary cell i want the most recent updated date. the cells are set up as following
Tittle Submission Original Submission New Actual Submission Date
Submission date 1/1/21 1/10/21 1/9/21
If no revised "new" dates have been set the cell would be blank along with the actual submission date
So really if date only in submission original, take that date, if date in submission new take that date, if date in actual submission take that date.
Look forward to you insights.
Help Article Resources
Check out the Formula Handbook template!