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

Try this: A1 = DOB B1 = DOH =DATEDIF(A1,B1,"y")>=40 That will return either TRUE or FALSE -- Biff Microsoft Excel MVP

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

Try =IF(DATEDIF(A1,TODAY(),"Y")>40,"yes","no") -- HTH Bob Phillips