Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula - Help!
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 |