How do I calculate the difference between 2 dates?
Comments
-
Are you wanting to get the number of calendar days or business days?
=networkdays([Column 8]23, [Column 8]25)
=netdays([Column 8]23, [Column 8]25)
Hope that helps!
-
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
-
This content has been removed.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives