Formula to count days between dates


Hello all. I am trying to figure out the correct formula that can bring back the amount of days between 2 dates.


I need to figure out the days between bid due to client and construction start date.


Bid due 3/01/24

Construction Start 5/20/24

There is a total of 81 days between these 2 dates. What formula would I use to bring back 81?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!