+6Hello!
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.
Best answer by TheTimeSavingCo
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.
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'
)
+31Hm depends on how your data's set up really, could you provide a screenshot of your data now?
+6Hm 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:
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.
+31Yes! 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.
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'
)+6I 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'
)You, my friend, are an absolute genius! Thank you so much! That is exactly what I needed!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.