When 1 sheet = a blank date field on another tab the result = 0-Ja
 

Using Excel 2003

How do I please get the result of the 'formula' to show BLANK when no date
is entered in the source field?

When a date IS entered in the source the display/value shown is fine.

Please advise

When 1 sheet = a blank date field on another tab the result =0-Ja
 

Try this:

=IF(Sheet1!A1="","",Sheet1!A1)

Hope this helps.

Pete

On May 22, 4:55*pm, Karen Ramel <Karen
wrote:
Using Excel 2003

How do I please get the result of the 'formula' to show BLANK when no date
is entered in the source field?

When a date IS entered in the source the display/value shown is fine.

Please advise

When 1 sheet = a blank date field on another tab the result = 0-Ja
 

=IF(A1="","",A1)
--
Gary''s Student - gsnu200787

When 1 sheet = a blank date field on another tab the result = 0-Ja
 

=IF(A1="","",A1)

Or a cross-sheet linking formula

=IF(Sheet1!A1="","",Sheet1!A1)


Gord Dibben MS Excel MVP

On Thu, 22 May 2008 08:55:01 -0700, Karen Ramel <Karen
wrote:

Using Excel 2003

How do I please get the result of the 'formula' to show BLANK when no date
is entered in the source field?

When a date IS entered in the source the display/value shown is fine.

Please advise