| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I stop Excel from treating blank cells as zero?
I'm calculating the difference between two dates, such as
A1 - 1st September B1 - 10th September So B1-A1 returns 9, which is great. But I only enter the dates in column B when a certain visit has been made, and while the cells in B are blank, Excel treats them as zero (or 1st Januray 1900). So B1-A1 returns -39000 odd. Is there a way to essentially stop it from calculating the formula until both cells have a value entered? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| existing excel file when clicked opens blank excel document | Excel Discussion (Misc queries) | |||
| how do I get excel to ignore blank cells in formulas | Excel Worksheet Functions | |||
| Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
| Non Blank - Blank Cells???? | Excel Discussion (Misc queries) | |||
| In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) | |||
Threaded Mode
