Feb 14 2022 09:40 PM
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.
Feb 14 2022 10:51 PM
Solution@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.
Feb 15 2022 12:52 PM
Feb 15 2022 12:58 PM
@Debbie_Faye Of course it works :))) Most welcome. Glad I could help!
Feb 22 2022 07:50 PM
Feb 22 2022 08:35 PM
Thanks for your question. I found this:
Feb 22 2022 08:45 PM
Feb 22 2022 09:01 PM
Feb 22 2022 09:03 PM
Just use it. You can use it.
Feb 22 2022 09:44 PM
@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.
Feb 22 2022 09:52 PM
Feb 14 2022 10:51 PM
Solution@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.