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.
date calculation
I want to calculate the actual number of workdays from a scheduled start date and scheduled finish date but i keep getting the wrong answer. a project started May 9, 2016 and is scheduled to complete on June 16, 2016. My date calculation says that's 27 work days which is incorrect. the formula i used is
=NETWORKDAY([Scheduled Start]13:[Scheduled Finish]13)
any ideas?
Comments
-
Hi!
One of the reasons why you don't have the good answer might be that you don't have the dependencies enabled... This might sound weird but enabling the dependencies gives you the option of adding non-working days.
Hope that helps!
Étienne Desbiens
-
thanks. i tried that and still calculates wrong
-
Can you give me your result and what you expect to see? And can I see the data you use to get to that result?
-
Do you know if your working days are set correctly? You (or whoever your smartsheet administrator is, if it isn't you) should be able to check what the working days are in the Admin Account Settings
-
For both NETWORKDAY() and NETWORKDAYS():
If Dependencies are turned off, I also get 27 days.
If turned on and no holidays, I get 29 days (which given no holidays, should be correct)
I can add two holidays to get it back to 27 days.
Since neither May 9 or June 16 are weekends, the same results from the two formulas is expected.
Oddly, June 3rd appears to be a problem:
It appears rose colored in the Gantt chart.
Dependencies are off. No holidays in the Account Settings
The numbers are the NETWORKDAY() formulas
I can't explain it but it looks wrong to me too.
Craig
-
i want to calculate the actual number of daya a project took - the project started
May 9, 2016 and completed on June 16, 2016. when using the following formula i get the wrong result.
=NETWORKDAY([Scheduled Start]13:[Scheduled Finish]13)
-
This appears to be a bug.
Craig
-
Hi Tom-- Can you right-click any column and open the Project Settings, then check under the Working Days section to see if any holidays are currently active on the sheet? If not, please share your sheet with me at Kennedy.Stomps@Smartsheet.com (offering Admin permissions) and we can troubleshoot this further.
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
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives