How do I calculate the difference between 2 dates?

Trying to track variable durations of past projects and simply want to subtract the start date from the completion date... depending on which format the column is in, I get various errors. Seems like I should be able to simply subtract one cell from the other, no?

Find more posts tagged with

Construction

Calendar View

Project Management

Comments

Mike Wilday

Are you wanting to get the number of calendar days or business days?

=networkdays([Column 8]23, [Column 8]25)

https://help.smartsheet.com/function/networkday

=netdays([Column 8]23, [Column 8]25)

https://help.smartsheet.com/function/netdays

Hope that helps!

Chris McKay

Hi jretzlaff,

Is Column8 a date formatted column?

Based on the Start and Turnover values, I'd say no.

If you cell-link dates in from a Date column and they land in a Text/Number column, Smartsheet will not treat them as dates. So even though Mike's formulas are 100% correct, you'll still get an error.

To make matters worse, Smartsheet uses the base format (i.e. Date) when a formula is entered into a Date column (even if you don't restrict the column to dates). Again Smartsheet.... Why? Whyyyyyyyyy?

I'd suggest applying Mike's formulas to a Date column and restricting the cell-links to dates only.

Kind regards,

Chris McKay

unknown

This content has been removed.

Sign in to join the conversation!

Quick Links

Trending discussions

Document filtered by form responses
I've created a Smartsheets form. When someone submits the form, I want them to automatically be emailed a document that has resources and links, but the document is filtered to only show the content that corresponds with what they selected in the form. Is something like this possible? What types of documents or automations…
Form stopped working after upgrade
I have a sheet that I created in a previous version, and it had a form. I was recently upgraded to a newer version and now my form is not working. I created a new form for the sheet, and it is giving me an error also. Does anyone know what I can do to fix this? The error says Form Unavailable. Sorry, the form you're trying…
Getting Error About Emulated Environments
Hi, I have read the post from 8/21/25. I am still getting the same error. I am setting up a new device and just download the latest version as of 9/5/25. I am using a Eunivon Smart White Board for touchscreen capability. It is running Android 14. Any help would be appreciated.