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

K

Karen Ramel

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
 
G

Gord Dibben

=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
 
Top