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,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

• Using Percentile with Specific Cell in Worksheet (0)
• Look to Cell References to a Worksheet (0)
• Conditional Formula in Different Worksheets (0)
• Writing a Formula Which Dynamically Generates Results (0)
• Intersection of Two Tabs in Excel Worksheet (0)
• IF Statement Calculating Average Has Numeric and Text (0)
• Automatically Insert Number of Days in Specific Month (0)

Comments

• Archives

  • October 2009
  • September 2009
  • August 2009
  • July 2009
  • June 2009
  • May 2009
  • April 2009
  • March 2009

• Categories

  • Excel Vba
  • Excel Tips
  • Excel Formulas
  • Excel Date Functions
  • Excel Spreadsheet
  • Excel Worksheet
  • Excel Miscellaneous

• Partners

  • Search Xls
  • Xls Files

• Latest Excel Tips

  • Search-Engine-Excel.Com - The Helpful One for You
  • Switch Minutes to Seconds in Excel
  • Excel Polynomial Trendline
  • Sending Multiple Personalized Email from Excel
  • Excel Sumif Multiple Criteria
  • Remove Hyperlinks in Excel
  • Copy Entire Rows to Another Spreadsheet Based on Cell Criteria
  • Streamlining Macro Created by Macros Recorder
  • Copying Cells Which Include Conditional Formatting in Worksheet
  • How to Draw Lines on User Form

• Most Viewed Excel Tips

  • How to Divide a Number With “Less Than” Sign? - 14,329 views
  • Date Calculation Start Date Minus Year, Month and Days - 14,034 views
  • Macro VBA to Remove Characters in String of Text - 13,222 views
  • Combine Multiple Workbooks Overcome 255 Char Limit - 11,974 views
  • Copy Entire Rows to Another Spreadsheet Based on Cell Criteria - 11,199 views
  • Protect Range of Rows and Columns in Worksheet with Macro - 11,032 views
  • Insert Introduce Time Delay in Macro Vba - 9,564 views

• Best Excel Tips

  • Calling Macro Visual Basic Procedures of a Different Project (5.00 out of 5)
  • Copy from Worksheet (5.00 out of 5)
  • Change Worksheet Tab Colors (5.00 out of 5)
  • Delete Worksheet (5.00 out of 5)
  • Quick Way Determine The First and Last Business Day of the Month (5.00 out of 5)
  • How to Calculate 6 Working Days Between Two Dates (5.00 out of 5)
  • Date Calculation Start Date Minus Year, Month and Days (5.00 out of 5)

• Excel Tags

  Excel Vba vba excel xcel vba vba xcel Excel Tips Excel Formulas excel formula xcel formulas xcel tips excel vba add worksheet excel vba create new workbook excel worksheet formulas xcel formula Excel Worksheet microsoft excel tips excel vba date functions excel date function Excel Spreadsheet excel vba active worksheet excel vba worksheet change excel vba worksheet name excel vba worksheet_change excel vba delete worksheet excel vba select worksheet excel vba clear worksheet excel vba copy worksheet excel vba macro add new worksheet how to add new worksheet excel miscellanous