Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DateDif Problem
I will try my best to explain myself. I have a worksheet in which cell A1:A6
contain Date of Birth, Cell B1:B6 contain the age by using =DateDiff(A1, Now(), "Y") and finally I have a question that asks if there is anyone =65 (years old), this question is an if, or statement. The issue is that when a cell in A1:A6 is blank the corresponding cell in column B returns a 106. Therefore my question always returns a "Yes" becuase if any cell in A1:A6 is blank I will get a 106. I would like to find a way to make this work. Any suggestions? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DateDif Problem
It's hard to say without seeing the formula, but you just need to test the A
value for blank. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Pattyt" wrote in message ... I will try my best to explain myself. I have a worksheet in which cell A1:A6 contain Date of Birth, Cell B1:B6 contain the age by using =DateDiff(A1, Now(), "Y") and finally I have a question that asks if there is anyone =65 (years old), this question is an if, or statement. The issue is that when a cell in A1:A6 is blank the corresponding cell in column B returns a 106. Therefore my question always returns a "Yes" becuase if any cell in A1:A6 is blank I will get a 106. I would like to find a way to make this work. Any suggestions? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DateDif Problem
Change your datedif formula to this...
=IF(A1=0, 0, DATEDIF(A1, NOW(),"Y")) Which will avoid the 106 (number of years elapsed since 1900) -- HTH... Jim Thomlinson "Pattyt" wrote: I will try my best to explain myself. I have a worksheet in which cell A1:A6 contain Date of Birth, Cell B1:B6 contain the age by using =DateDiff(A1, Now(), "Y") and finally I have a question that asks if there is anyone =65 (years old), this question is an if, or statement. The issue is that when a cell in A1:A6 is blank the corresponding cell in column B returns a 106. Therefore my question always returns a "Yes" becuase if any cell in A1:A6 is blank I will get a 106. I would like to find a way to make this work. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing from Excel Sheet Problem | Excel Discussion (Misc queries) | |||
Excel Startup Problem | Excel Discussion (Misc queries) | |||
Problem with MS Community Newsgroups? | Excel Discussion (Misc queries) | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) |