Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date Formula | Excel Discussion (Misc queries) | |||
Date formula | Excel Discussion (Misc queries) | |||
Formula to determine a future date based on criteria | Excel Worksheet Functions | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) |