Formula help dates

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

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.

1 Like

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.

Would there be a way to exclude certain statuses?

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.