Linked date field in worksheet defaults a blank field as 1/0/1900
Hi
Include an If statement in your formula like
=IF(Sheet1!A1="","",Sheet1!A1)
--
Regards
Roger Govier
"AmnNkD" wrote in message
...
I have a workbook that has several worksheets linked. When the date
fields
are blank in the orginial worksheet the worksheet they are linked to
shows
the dates as 1/0/1900, not a blank field. Does anyone know how to fix
this?
Thank you!
|