Calcualating age by month day and year

[CandiCorn5000]

I am trying to calculate the age of employees on the date of the injury...not
just by the year. I have been trying this formula...

=DateDiff("yyyy",[DOB],[Date of Injury])+(Format([DOB],"mmdd")>Format[Date
of Injury],"mmdd"))

any suggestions?

 

[John W. Vinson]

I am trying to calculate the age of employees on the date of the injury...not
just by the year. I have been trying this formula...

=DateDiff("yyyy",[DOB],[Date of Injury])+(Format([DOB],"mmdd")>Format[Date
of Injury],"mmdd"))

any suggestions?

You want the age in the form 31 years, 2 months, 6 days? If so try Graham
Seach's Diff2Dates function as posted by Doug Steele:

http://www.accessmvp.com/djsteele/Diff2Dates.html