View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default 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!