NULL result instead of date

[Hobbes25]

Hi all,

I'm trying to write a formula that takes the dates from 3 separate columns compares them and then returns to me the most recent date. However, some of these columns occasionally contain NULL values. As of now my formula looks like the following:

=IF(C:C>D:D,C:C, IF(D:D>E:E,D:D,E:E ))

It works well up until a null is presented in one of, or multiple of the rows. I've tried several different ways to handle the errors like setting NULL to 0, by using an IF statement that precedes the others, but it still returns NULL. Anybody have any tips on how to get past this?

 

[Hobbes25]

Hi all,

I'm trying to write a formula that takes the dates from 3 separate columns compares them and then returns to me the most recent date. However, some of these columns occasionally contain NULL values. As of now my formula looks like the following:

=IF(C:C>D:D,C:C, IF(D:D>E:E,D:D,E:E ))

It works well up until a null is presented in one of, or multiple of the rows. I've tried several different ways to handle the errors like setting NULL to 0, by using an IF statement that precedes the others, but it still returns NULL. Anybody have any tips on how to get past this?

I was able to make a workaround. Just in case anybody else runs into this kind of problem just use:

MAX(C:C,D:D,E:E)