# 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.

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?

• ✭✭✭✭✭✭

=[Construction Start]@row - [Bid Due]@row

This will give you 80 days. If you want to include the first day, you can just add one back.

=[Construction Start]@row - [Bid Due]@row + 1

• ✭✭✭✭✭✭

You would use basic subtraction in this case.

=[Construction Start]@row - [Bid Due]@row

• ✭✭✭✭✭✭

=[Construction Start]@row - [Bid Due]@row

This will give you 80 days. If you want to include the first day, you can just add one back.

=[Construction Start]@row - [Bid Due]@row + 1

• ✭✭✭✭

That was easy enough! I think the issue I was having is that one of the columns was not set as a date column. Thanks for your help!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!