Calculating age from two date fields-Excel 2003

[Veteran of the Software Cycles]

I'm not sure what section this question should go in.

I need to find if a person was 40 years of age or older (= or >) at his Date
of Hire. I have two columns, Birth Date and Date of Hire.

How would I write a formula to give me this answer?

Thanks in advance

 

[T. Valko]

Try this:

A1 = DOB
B1 = DOH

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

That will return either TRUE or FALSE

--
Biff
Microsoft Excel MVP


"Veteran of the Software Cycles"

 

[s. suganthi]

please tell me the way how to calculate the age from 2 dates



VeteranoftheSoftwareCycle wrote:

Calculating age from two date fields-Excel 2003
30-Mar-09

I'm not sure what section this question should go in

I need to find if a person was 40 years of age or older (= or >) at his Date
of Hire. I have two columns, Birth Date and Date of Hire.

How would I write a formula to give me this answer

Thanks in advance

Previous Posts In This Thread:

Calculating age from two date fields-Excel 2003
I'm not sure what section this question should go in

I need to find if a person was 40 years of age or older (= or >) at his Date
of Hire. I have two columns, Birth Date and Date of Hire.

How would I write a formula to give me this answer

Thanks in advance

Re: Calculating age from two date fields-Excel 2003
Try this

A1 = DO
B1 = DO

=DATEDIF(A1,B1,"y")>=4

That will return either TRUE or FALS

-
Bif
Microsoft Excel MV

"Veteran of the Software Cycles"

EggHeadCafe - Software Developer Portal of Choice
Xselerator 2.0
http://www.eggheadcafe.com/tutorials/aspnet/9f2100e9-a912-42a3-8d34-a243ac125be0/xselerator-20.aspx

 

[Bob Phillips]

Try

=IF(DATEDIF(A1,TODAY(),"Y")>40,"yes","no")