Formula help dates

[Jessi_Burns]

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

[Nick_Dennis · Accepted solution]

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.

[Jessi_Burns]

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.

[Jessi_Burns]

Would there be a way to exclude certain statuses?