Excel Formula, who will be age 55 by 12/31/2007 and 6/30/2009?
 

It's for my project. I need the formulas to input the data. Please help!!!

Excel Formula, who will be age 55 by 12/31/2007 and 6/30/2009?
 

Clearly anyone born on or before 12/30/1952 will be 55 by 12/31/2007
and anyone born on or before 6/29/1954 will be 55 by 6/30/2009

Put DOB and 12/30/1952 in A1,B1 and use =IF(A1<=B1,"yes","no") first case
Put DOB and 6/29/1954 in A1,B1 and use =IF(A1<=B1,"yes","no") next case
--
Gary's Student


"Containsmiles" wrote:

It's for my project. I need the formulas to input the data. Please help!!!

Excel Formula, who will be age 55 by 12/31/2007 and 6/30/2009?
 

Check Chips' site www.cpearson.com for the use of DATEDIFF
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Containsmiles" wrote in message
...
It's for my project. I need the formulas to input the data. Please
help!!!