| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exclude blank data from formula calculation
I have a formula =YEAR($J$1)-YEAR(C2) calculating age from date of birth.
However some of my entries do not have an entry for date of birth, so their 'age' ends up as being (for example) 108. Is there a way of making sure the formula does not calculate these ages? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exclude Cell from Calculation | Excel Discussion (Misc queries) | |||
| How do I set up a calculation to exclude weekends? | Excel Worksheet Functions | |||
| Date Calculation to exclude weekends | Excel Worksheet Functions | |||
| Exclude non-numeric data from calculation | Excel Worksheet Functions | |||
| calculation to exclude weekends | Excel Worksheet Functions | |||
Threaded Mode
