ContributionsMost RecentMost LikesSolutionsRe: Calculating a rolling count of days between two dates if one is emptyThe formula takes without error, which is fantastic. I wasn't getting any values in the target field at first, but it was successful after I had adjusted the destination field to Formula-Numeric in order to give me the number of days instead of Formula-Duration. Thanks again. Just out of curiosity - is it typical to set variables and use special characters ($EndDate) when creating a formula? How would you recognize when to use these functions?Calculating a rolling count of days between two dates if one is emptyI have two main date fields and I want to track the number of days between them. Imagine "Open" and "Closed" dates, where my "Number of Days" will equal the difference between "Open" and Today's date, until I input a "Closed" date. I'm putting together an If statement using Null, but I'm not quite there yet. Formula is below: If(IsNull(ToDays([Pit Backfilled On]-[Pit Open Date]),ToDays(Today()-[Pit Open Date]))) Thank you!