Comparing dates
I have a simple spreadsheet, consisting of three columns.
Col A Col B Col C
Date1 Date2 EarliestDate
I need help with a formula in Col C (EarliestDate) that must display the earliest date either in Col A or B.
My formula below shows as too many arguments.
I tried this but no good:
“=IF(AND(Date1=””,Date2=””),”none”,IF(Date1=Date2,Date1,IF(Date2=””,Date1,Date2),IF(Date1<Date2,Date1,Date2))))”
Any ideas please from you experts?
Versions:
Mac OS 10.15.7 (Catalina)
Word 16.66.1
Excel 16.66.1
I have a simple spreadsheet, consisting of three columns.Col A Col B Col CDate1 Date2 EarliestDateI need help with a formula in Col C (EarliestDate) that must display the earliest date either in Col A or B.My formula below shows as too many arguments. I tried this but no good:”=IF(AND(Date1=””,Date2=””),”none”,IF(Date1=Date2,Date1,IF(Date2=””,Date1,Date2),IF(Date1<Date2,Date1,Date2))))”Any ideas please from you experts? Versions:Mac OS 10.15.7 (Catalina)Word 16.66.1Excel 16.66.1 Read More