Use MIN for a non-range when there can be blanks

[JustHooch]

I am looking to find the Min date from 3 cells that are not a range. I thought to use MIN, however, there are cases where the at least one of the 3 cells are blank.

Example: =MIN(J23,I97,I78)

Cells J23, I97, I78 are all populated by formulas which can sometimes have a blank ("") results.

My problem is that if any of the cells in the MIN formula (cells J23, I97, I78) are blank I get a #VALUE error.

Is there a way to make MIN work with blanks for non-ranged values or is there something I can do to get the same result?

 

[Scott Huish]

MIN will ignore text and blank values.

Do you perhaps have #VALUE ! errors in any of those cells that might be hidden by conditional formatting?

 

[JustHooch]

There are no #Value errors other than the one in the Min formula, I double checked.

 

[JustHooch]

I figured out the issue. It was not with the MIN formula but with the WORKDAY formulas I had nested.

What I did have: =MIN(WORKDAY(J23,-1,Holidays!$B$5:$B$34),WORKDAY(I97,-1,Holidays!$B$5:$B$34),WORKDAY(I78,-1,Holidays!$B$5:$B$34))

I changed it to: =WORKDAY(MIN(J23,I97,I78),-1,Holidays!$B$5:$B$34) and it is now working as it should.