Calcualating age by month day and year

  • Thread starter Thread starter CandiCorn5000
  • Start date Start date
C

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?
 
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?
Click to expand...

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
 
Back
Top