Forum Discussion
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 to calculate one or the other (like: Current age or DOD age), but I need the formula to figure out that if there is not a DOD to continue to calculate the age of the employee for the current date.
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.
10 Replies
Thanks for your question. I found this:
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!
