Clive_RabsonBrass ContributorMay 24, 2024SolvedComparing 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 dis...Show MoredscheikeyMay 24, 2024Clive_Rabson That should provide the solution:=IF(AND(Date1="",Date2=""),"none",MIN(Date1,Date2))
dscheikeyMay 24, 2024Clive_Rabson That should provide the solution:=IF(AND(Date1="",Date2=""),"none",MIN(Date1,Date2))
dscheikeyMay 24, 2024Clive_Rabson That should provide the solution:=IF(AND(Date1="",Date2=""),"none",MIN(Date1,Date2))
dscheikeyBronze ContributorMay 24, 2024Clive_Rabson That should provide the solution:=IF(AND(Date1="",Date2=""),"none",MIN(Date1,Date2))
Clive_RabsonBrass Contributor to dscheikeyMay 24, 2024dscheikey Thank you. Very simple and elegant.I am embarrassed.
