Formula to ascertain latest date in multiple columns

[Kcurrie]

=IF(CODE(F26)=32,IF(CODE(E26)=32,IF(CODE(D26)=32,IF(VALUE(C26)=0,"",C26))))

this is what was in the cell before but the person that wrote this is no longer available and the formula no longer works.

Any suggestions? Wish I could attach a screen shot.

 

[Joe4]

That formula does not look like it is pulling the latest date from multiple columns. Code(32) is the ASCII code representation for a single space. So it is checking to see if F26, E26, and D26 all have a single space in them, and if they do and if the value of C26 is anything other than zero, it will return what is in C26. Otherwise, it is going to return "FALSE".

You can attach screen shots using the programs mentioned here: http://www.mrexcel.com/forum/showthread.php?t=508133

 

[Kcurrie]

Nevermind ..... fixed it using the MAX function ... duh!

 

[Arul.rajesh]

If F26,E26 and G26 begin with a space and c26 is greater than 0, then the formula would return the value in c26, otherwise it leaves it blank.