Count number of Days


I have tried looking here for answers but not able to find the formula that will work. I have a Install Date and Install End Date. These fields are date fields. The Days field I want the formula to appear is a text field.

I need to calculate the number of days.

4/09/2024-04/-9/2024 would be 1 day

4/10/24 - 4/12/25 would be 3 days

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!