How would I calculate days in foster care from the intake date to today but have it stop counting once the animal’s status is adopted? Ive got the intake date and adopted date but wasnt sure how the formula should be worded.
an example of the info
Solved
Formula help dates
Best answer by Nick_Dennis
Hi @Jessi_Burns!
Are there any other Status options besides “Available” and “Adopted”?
If not, then I think you’re looking for a formula like this:
IF(Status = "Adopted" ,DATETIME_DIFF({Adopted},{Intake}, 'days'), DATETIME_DIFF(TODAY(),{Intake}, 'days'))
This will count the number of days between Intake and Adopted if the Status is “Adopted”. Otherwise it will count the number of days from Intake to today. If there are other status possibilities then this might need to be tweaked slightly.
Hope that helps.
+14Hi @Jessi_Burns!
Are there any other Status options besides “Available” and “Adopted”?
If not, then I think you’re looking for a formula like this:
IF(Status = "Adopted" ,DATETIME_DIFF({Adopted},{Intake}, 'days'), DATETIME_DIFF(TODAY(),{Intake}, 'days'))
This will count the number of days between Intake and Adopted if the Status is “Adopted”. Otherwise it will count the number of days from Intake to today. If there are other status possibilities then this might need to be tweaked slightly.
Hope that helps.
Hi @Jessi_Burns!
Are there any other Status options besides “Available” and “Adopted”?
If not, then I think you’re looking for a formula like this:
IF(Status = "Adopted" ,DATETIME_DIFF({Adopted},{Intake}, 'days'), DATETIME_DIFF(TODAY(),{Intake}, 'days'))
This will count the number of days between Intake and Adopted if the Status is “Adopted”. Otherwise it will count the number of days from Intake to today. If there are other status possibilities then this might need to be tweaked slightly.
Hope that helps.
Yeah there’s quite a few, around 13. Really only Available, Hold, Pending, and Adopted need the date, the rest either don’t apply or wouldn’t have both dates anyway.
Hi @Jessi_Burns!
Are there any other Status options besides “Available” and “Adopted”?
If not, then I think you’re looking for a formula like this:
IF(Status = "Adopted" ,DATETIME_DIFF({Adopted},{Intake}, 'days'), DATETIME_DIFF(TODAY(),{Intake}, 'days'))
This will count the number of days between Intake and Adopted if the Status is “Adopted”. Otherwise it will count the number of days from Intake to today. If there are other status possibilities then this might need to be tweaked slightly.
Hope that helps.
Would there be a way to exclude certain statuses?
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.