Forum Discussion

Copper Contributor

Jun 23, 2021

Solved

formula use to return earliest date or leave it blank

I need the formula that can fit into most earliest delivery date column by a. return earliest date among Date 1 , Date 2 and Date 3. b. return the date if only have one date among the Date 1,2,3 ...

Formulas and Functions

Lorenzo
Jun 23, 2021
MeiChan1314

in B2 (and copy down if you don't use a Table):
=IF(COUNT(C2:E2), MIN(C2:E2), "")

Lorenzo

Silver Contributor

Jun 23, 2021

MeiChan1314

in B2 (and copy down if you don't use a Table):

=IF(COUNT(C2:E2), MIN(C2:E2), "")

MeiChan1314

Copper Contributor

Jun 25, 2021

thanks it works! Just a question if the data from column date 1 , 2, 3 is carry out from another excel sheet means contain formula, does the above IF +Count+Min still working?

Lorenzo
Silver Contributor
Jun 25, 2021
MeiChan1314
Of course, something you coul have easily checked 🙂
However, make sure the formulas involved in filling your Date1-Date3 columns return something like "" and not 0 when there's no data avail. in the other sheet, otherwise MIN will find/report the 0s
Other option is to use Sergei's formula
- MeiChan1314
  Copper Contributor
  Jun 25, 2021
  Thank you so much!
  - Lorenzo
    Silver Contributor
    Jun 25, 2021
    You're welcome. If your solution doesn't need to be shared with people not running Excel 365, Sergei's option would be the way to go IMHO. Nice day...