Forum Discussion
Solved
Employee Current Age or Age at DOD
Does anyone know if there is a formula that will show an employee's Current Age (as of TODAY) OR if there is a Date of Death present, what the Age was when they deceased? I seem to only know how ...
Debbie_Faye Perhaps like this:
It calculated age on today's date if DOD is blank, otherwise it calculates the age at death. Ages are presented in one decimal, but you can round at as you wish.
Debbie_Faye Of course it works :))) Most welcome. Glad I could help!
Riny, Do you have any suggestions for how to present the Age as Years and Months? I'm dealing with data that has infants in it. So it's DOB referencing a session date to get Age at the session. 1.8 When the point 8 represents 80% isn't so clear.
- Without using DATEDIF, unfortunately. Still on Office 2019 on desktop.
Riny_van_Eekelen solution does not suit your needs unless you have the definition about "the month difference", e.g. assume each month 30 days. Otherwise, Riny's solution cannot suit your needs to turn the overall day difference to "the number of years and month difference".
If I am wrong, please correct me. I am also learning too.
- I had Riny's solution get me totals that were close enough. Once I had the difference as a number of days, I divided by 30.5 to give me a ballpark Month count. But that wouldn't help with years, I think I'd be doing some sort of calculation to work out How many years in X days, then working out how to calculate the remainder into Months, then getting it to format correctly. When you're just dealing with older ages it would have been great, and I'll use it again, but when I'm trying to humanise the data into plain English and account for folks talking about ages in Months and then at some random point between 1-3 going to Years and Months, it's tricky.
Thank god Datedif works. No syntax help, but it does work.
Just use it. You can use it.
