Calculate details for a coffin nameplate (# Years, # Months, # Days)

Question

Hi, I need to calculate the age of a Deceased. I assume a formula is needed. I have Date of Birth and Date of Death to work with and I need the know the age in Years, Months and Days.
Any help would be greatly appreciated.

Kamille_Parks11 · Accepted Answer

Fairly straightforward until you get to the days component. Not sure if there’s a more efficient formula than:

DATETIME_DIFF({Date of Death}, {Date of Birth}, "years") 
& " years, " 
& MOD(DATETIME_DIFF({Date of Death}, {Date of Birth}, "months"), 12) 
& " months, " 
& DATETIME_DIFF(
   {Date of Death}, 
   DATEADD({Date of Birth}, DATETIME_DIFF({Date of Death}, {Date of Birth}, "months"), "months"), 
   "days"
) 
& " days"

That works amazingly. Thank you so much! If ever you need a nameplate, just shout :winking_face:

Ross_Drummond1 · Answer

Fairly straightforward until you get to the days component. Not sure if there’s a more efficient formula than:

DATETIME_DIFF({Date of Death}, {Date of Birth}, "years") 
& " years, " 
& MOD(DATETIME_DIFF({Date of Death}, {Date of Birth}, "months"), 12) 
& " months, " 
& DATETIME_DIFF(
   {Date of Death}, 
   DATEADD({Date of Birth}, DATETIME_DIFF({Date of Death}, {Date of Birth}, "months"), "months"), 
   "days"
) 
& " days"

That works amazingly. Thank you so much! If ever you need a nameplate, just shout :winking_face:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded