Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I've got two columns (D, E) headed DOB and Age. Basically what I'm looking
for is a forumula which looks at D, puts the amount of years in E as in: =DATEDIF(D210,TODAY(),"y") but not display anything if D is blank. What I came up with is: =IF(D2="","",(DATEDIF(D2,TODAY(),"y"))) but that doesn't seem quite right. It works but Excel says there's an error in it. Any help please? Thanks in advance. --D. -- I would give my left hand to be ambidextrous! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
JUST A SIMPLE DATE PLEASE! | Excel Discussion (Misc queries) | |||
Most simple formula to calculate date+ 30 months? | Excel Worksheet Functions | |||
Simple (I Think) Date Formula Needed | Excel Discussion (Misc queries) |