Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Difference in Days between Projected & Actual Start Dates/ End Dates?
My managers want a column that calculates number of work days (Mon. - Fri) between Projected Start Date and Actual Start Date. Example: Projected Start Date (in Column A): 09/01/16. Actual Start Date (in Column C): 09/09/16. Difference in Days between projected and actual start dates (Column : 6 Days.
What formula would I use in Column B to get the number of work days between Projected and Actual Start dates?
(This calculation might also be useful to calculate difference in work days between stated "Need By" date and actual completion date in another column).
Thanks!
Comments
-
I found the answer to my question in the Help Center, it was basically this, the NETWORKDAYS formula... and yes, it works!
NETWORKDAYS()
Returns the number of working days between a start date and end date.
Syntax: NETWORKDAYS(start, end, <holiday_range>)
Arguments:
- start - Required. The start date
- end - Required. The end date.
- holiday_range - Optional. The dates to exclude from the count (for example, holidays or other specific dates).
Examples:
=NETWORKDAYS([Due Date]4, [Due Date]5)
Result: 20=NETWORKDAYS([Due Date]1, [Due Date]5, [Due Date]2:[Due Date]3)
Result: 85NOTE: By default, the WORKDAYS, NETWORKDAY, and NETWORKDAYS formulas count Saturday and Sunday as non-working days. If dependencies are enabled on your sheet you can customize the non-working days, and the formulas will use your settings in calculations.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives