# Calculate birthdate with given years and months

Topic Labels: Formulas
Solved
Jump to Solution
1643 4
cancel
Showing results for
Search instead for
Did you mean:
5 - Automation Enthusiast

Hello!

I'm hoping you guys can help. I'm a total newb with formulas.

I'm trying to build a animal shelter manager and usually we don't have the exact date of birth. Just an approximate age (ie, 2 years, 5 months, 4 days, etc.). Is there a formula that can calculate an approximate date from those numbers?

I've looked everywhere and tried a million different formulas.

1 Solution

Accepted Solutions
18 - Pluto

I see, thanks!  We'll need to create a "Created Time" field to log the date the form was submitted so that we have a starting point, then we can use a formula field like so:

``````DATEADD(
DATEADD(
DATEADD(
Created,
-Days,
'days'
),
-Months,
'months'
),
-Years,
'years'
)``````
4 Replies 4
18 - Pluto

Hm depends on how your data's set up really, could you provide a screenshot of your data now?

5 - Automation Enthusiast

Yes! Here is how I have it set up so far:

This is from Shelterluv, an animal shelter management system. When intaking the animal, it will ask the age in years, months, and days and then it will calculate the estimated birthdate.

18 - Pluto

I see, thanks!  We'll need to create a "Created Time" field to log the date the form was submitted so that we have a starting point, then we can use a formula field like so:

``````DATEADD(
DATEADD(
DATEADD(
Created,
-Days,
'days'
),
-Months,
'months'
),
-Years,
'years'
)``````
5 - Automation Enthusiast

You, my friend, are an absolute genius! Thank you so much! That is exactly what I needed!