Formula to count days between dates

Options

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

Example:

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

Column:

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!