dates missing

[Jerie]

In sheet1 Ihave the same dates in cells A1
A10
A20
I have to use these dates in sheet2
If the date in cell A1 is missing what formulla can I use
to say go to cell A10 or A20 and use that date? or if any
one of those dates ar missing what can i use?

Your help is very much apprciated, Thank You

 

[duane]

if they are all the same, or missing, how about (max (a1, a10, a20)