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