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
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives