Calculate Age from Two Date Cells

April 5, 2009 by vba excel
Filed under: Excel Formulas 
Sponsor

Excel Formulas Calculate Age from Two Date Cells [Q]

Ive a problem related to microsoft excel formulas, I need to find if a person was 40 years of age or older (= or >) at his Date of Hire. I have two columns or cells in excel worksheet, Birth Date and Date of Hire. How would I write excel formula to give solve this excel problems?

Excel Formulas Calculate Age from Two Date Cells [A]

Try this excel formulas to calculate age from 2 date columns or cells:

A1 = DOB
B1 = DOH

=DATEDIF(A1,B1,”y”)>=40

The excel formulas above will return either TRUE or FALSE

  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Google
  • E-mail this story to a friend!
  • Live
  • MisterWong
  • Propeller
  • StumbleUpon
  • Technorati
  • TwitThis
  • YahooMyWeb
  • Print this article!

Rate This Tips:

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...


Incoming excel search terms

excel formula calculate age,excel calculate age,calculate age in excel,age formula in excel,excel formulas for age,calculating age in excel,how to calculate aging in excel,calculate age from date of birth in excel,calculate age excel,excel calculate age date birth,age calculation formula in excel,aging formula in excel,excel aging formula,excel formulas age,excel vba calculate age,excel age between two dates,excel age formula,excel calculate age from date of birth,age excel formula,calculate age in excel from date of birth,calculate age in excel vba,excel formula age,vba calculate age,calculate age date excel,calculate age from date of birth excel,calculate aging in excel,excel age,excel formula to calculate age,how to calculate age in excel,,ageing formula in excel,calculate age excel spreadsheet,calculating age excel,calculation of age in excel,excel age macro,excel calculate date of birth by age,excel formula age calculation,f,how to calculate ageing in excel,how to find ageing formula in excel,0,age as at a certain date excel,age calculation formula excel,age date text excel,age excel vb,age formula excel,age formulas,aging excel formulas,birth date cell macro,calculate age date birth excel



Related Excel Tips

Comments

2 Comments on Calculate Age from Two Date Cells

  1. AMANDEEP SINGH on Tue, 21st Jul 2009 9:02 am
  2. PLEASE TELL ME MY PROBLEM SOLUTION ON THE EXCEL COMMANDS
    EXPLAIN THE PROBLEM MY DATE OF BIRTH IS 10 OCT 1983 & NOW MY
    AGE AND MONTH AND DAY PLZ NEEDFUL FUL MY PROBLEM

    THANX
    WARMS REGARDS
    AMANDEEP SINGH
    9779209507

  3. Talitha on Fri, 12th Feb 2010 9:40 pm
  4. Hi! May you please help? I want to use a formula to calculate an age from two dates with out manual input. I also need to know how to copy the folmula to include the successive cells up to 230. In other words how do I apply the formula to the entire spread sheet (all of the rows in a column) and not just one row.

    Thank you.

Have another excel answer or questions for this problem ?
Feel free to post it here..