Calculate Age from Two Date Cells
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
Rate This Tips:
Incoming excel search terms
excel formula calculate age,excel calculate age,calculate age in excel,how to calculate aging in excel,age formula in excel,mss,excel aging formula,excel formulas for age,calculate age from date of birth in excel,excel formula to calculate age,calculating age in excel,excel age formula,excel vba calculate age,age calculation formula in excel,calculate age excel,aging formula in excel,excel calculate age date birth,excel calculate age from date of birth,excel formula age,excel formulas age,how to calculate age in excel,age excel formula,calculate age from date of birth excel,calculate age in excel vba,calculate aging in excel,excel age between two dates,ageing formula in excel,calculate age in excel from date of birth,excel age,how to calculate ageing in excel,vba calculate age,calculate age date excel,excel formula age calculation,,age calculation formula excel,age formulas,calculate age excel spreadsheet,calculate age in excel from two dates,calculating age excel,calculating age using two dates in excel,calculation of age in excel,excel age at date,excel age calculation,excel age macro,excel aging,excel calculate age between two dates,excel calculate date of birth by age,excel formula for age,excel formula for age from date,excel formulas calculate age
Related Excel Tips
Comments
3 Comments on Calculate Age from Two Date Cells
-
AMANDEEP SINGH on
Tue, 21st Jul 2009 9:02 am
-
Talitha on
Fri, 12th Feb 2010 9:40 pm
-
Mohammed Ali on
Mon, 22nd Mar 2010 9:47 am
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
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.
Can you elaborate your question.
Have another excel answer or questions for this problem ?
Feel free to post it here..















