Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linked date field in worksheet defaults a blank field as 1/0/1900
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linked date field in worksheet defaults a blank field as 1/0/1900
Let's say SourceSheet is the sheet where you have your date, in Cell A1.
TargetSheet cell A1 is where you are going to pull in the date from SourceSheet A1. At the moment your formula in TargetSheet A1 is something like this =SourceSheet!A1 You need to change it to this =IF(SourceSheet!A1="","",SourceSheet!A1) -- Allllen "AmnNkD" wrote: 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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Using a date field in mail merge | Excel Discussion (Misc queries) | |||
Field , Date range and Sum from worksheet import | New Users to Excel | |||
Copying blank excel worksheet into additional excel workbooks | Excel Discussion (Misc queries) | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel |