Thread: Date Formula
View Single Post
  #2   Report Post  
Kevin M
 
Posts: n/a
Default

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
.