Help

Calculate birthdate with given years and months

Topic Labels: Formulas
Solved
Jump to Solution
2425 4
cancel
Showing results for 
Search instead for 
Did you mean: 
reagand
5 - Automation Enthusiast
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

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'
)

Screenshot 2023-03-29 at 2.30.50 PM.png
Link to base

See Solution in Thread

4 Replies 4

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

Yes! Here is how I have it set up so far:
Screenshot 2023-03-28 115154.png

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.

Screenshot 2023-03-28 115502.png

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'
)

Screenshot 2023-03-29 at 2.30.50 PM.png
Link to base

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