Hi! I want to show (and then sort later on) the earliest date of two.
The situation: I have dates that meetings are due, and dates that meetings are scheduled. I need to see both so that I know how to plan accordingly.
The table:
Row Headers:
Name | Due Date | Scheduled Date | Earliest
Bob | 3/24/21 | [blank] | 3/24/21
Sue | 2/24/21 | 1/24/21 | 1/24/21
I’m looking for the formula I’d need on the “Earliest” column, assuming there will be blanks.
Thanks!