I am trying to write a formula to show the 'soonest' date out of 2 columns,
but if both the columns are blank then show blank.

So far I have:

=IF(AA3AB3, AA3, AB3)

Which correctly shows the date, but where there is blanks it is dragging
through a date of 00/01/1900.

Can anyone help me extend my formula?

Many Thanks

Helen