Date Formula
 

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

i Kara, this should work:

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

HTH.
Kevin

-----Original Message-----
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
.

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

"Kara" wrote:

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