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 am not shocked it works, but just coming in to say thanks. Just what I needed for something else. Cheers!
