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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

It's for my project. I need the formulas to input the data. Please help!!!
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If statements?? 2
Count if between date parameters 4
possible countif formula? 3
How do I determine who will be age 55 by 12/31/2007 and 6/30/2009? 1
IF ISERROR INDIRECT MATCH Formula Question??? 19
Transpose columns to rows using first columns repeated. 7
How do I calculate age using a 12 digit social security number in MS Excel? 0
Please help with formula (multiple ifs to determine due date) 3

Back
Top