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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to get the number of days an item was opened from the today's date. 14
Calculating age from date of birth and ignoring if blank 5
Excel Average dates help 0
Link cell between WS w/o dest display 0-jan if no entry at source 1
Sumifs - incorrect when using date in critera 3
Access Property sheet data missing also syntax 0
blank vs. 0 when plotting a dated timescale graph 1
Counting Results of Formulas 1

Top