Beginner: Issue with blank cells when formula is working out greater of two dates

[joz110820]

I'm new to excel and am updating a training database. Collumn M has a formula in it that gives me the greater of the dates in I and K collumns. I'm finding that the blank cells put 00/01/1900 in the M collumn. I would like for those ones just to be blank. I've been googling and trying formula after formula with no success, keep getting error messages. Could anyone help me?

 

[AlphaFrog]

Try something like this...

=IF(MAX(I5,K5)=0,"",MAX(I5,K5))

 

[ExceLoki]

try this

=IFNA(IFS(I5>K5,I5,I5<K5,K5),"")

 

[Fluff]

Or even

=LET(m,MAX(I5,K5),IF(m=0,"",m))

 

[joz110820]

try this

=IFNA(IFS(I5>K5,I5,I5<K5,K5),"")

try this

=IFNA(IFS(I5>K5,I5,I5<K5,K5),"")

This worked! Thank you so much!

 

[Fluff]

There is no nee for the ifna, you can just use a default value like

=IFS(I5>K5,I5,I5<K5,K5,1,"")