You are viewing limited content. For full access, please sign in.

Question

Question

Determine age as of a certain date based on date of birth

asked on August 17, 2020

Is it possible to write some sort of date formula that will take a Date of Birth and not just calculate their age, but their age as of a set date? In my particular example, I'd like to be able to calculate someone's age based on their date of birth as of 10/1/2020. I'm racking my brain to try and come up with something in a hurry and was hoping someone might have thoughts as to how to make this work. Thanks!

1 0

Answer

SELECTED ANSWER
replied on August 17, 2020

Check out this Answers post from this morning:

https://answers.laserfiche.com/questions/177368/Age-calculation-error-in-table#177369

Susan uses a DatedIF formula

DATEDIF(Birthday,SomeDate,"y")

Hers may be a little more complex in that she's doing this per each row in a table, but the concept is the same, just give it a birthday and your future date. 

1 0
replied on August 17, 2020

Jared,

Thank you very much! It took me a bit, but I managed to pull something together from that that's working as it should. I appreciate the assist. Have a great rest of your day sir!

1 0

Replies

replied on March 22, 2021

This method is not accurate to the day (using TODAY()) as the DATEDIF function it does not account for leap years.  The age is approximate and not to the actual birthdate so if age is important in a legal or other context, this will not do it accurately.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.