Date may appear in any of three different cells

[dbagnell]

Hi everyone,

I'm stumped. In my excel file, B2 will always have a date. If C2 and D2 may display a date, nothing at all or zeros. I want the correct date to display in E2.

B2 always has a date. If C2 has a date that isn't 0, I want to use that one instead of B2. And if D2 has a date that isn't 0, I want to use it instead of C2 or B2.

How would I go about this?

Thanks!

 

[JoeMo]

in E2:

=IF(D2>0,D2,IF(C2>0,C2,B2))

Format B:E cells as Date