=IF(A9="","",'DOWNLOAD WO SHORTAGE LIST'!D9)


This formula looks in Cell A9 for a works order #
If it is blank it will return blank
Else go to worksheet 'DOWNLOAD WO SHORTAGE LIST'
Pick up the date in cell D9

My question: How do I expand this statement to include
IF D9 in 'DOWNLOAD WO SHORTAGE LIST' has no date then Blank else date.

Presently it returns the excel default 01/01/1900