Date Formula

[Guest]

I have two spreadsheets set-up. Sheet 1 is TypeInData and Sheet 2 is
SaveCSV_file. On TypeInData I have a column that is formatted to show dates
in the dd-mmm-yy format. When I go to SaveCSV_file and enter the formula
=TypeInData!H13 it will enter 0-Jan-00 if nothing is entered into H13. How
can I make that field blank if nothing is typed into H13 on the TypeInData
spreadsheet?

I have tried an IF statement, an IF statement with ISBLANK, an IF statement
with ISText and I cannot seem to get any of them to work.

Thanks for your help!

Kara

 

[Kevin M]

i Kara, this should work:

=if(typeindata!h13="","",typeindata!h13)

HTH.
Kevin

 

[Guest]

Dear Kara,

This is an IF statement I use for a similar problem - maybe it will work for
you.
(It worked when I tested it anyway.)

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

Sincerely,
Beverly