Public holidays duration
Hello everyone
I am working on a use case and I have a problem with a duration value (using Smartsheet in french) :
I calculated the number of working days for 2021 in France and it is 254, in Smartsheet I have a result of 255
As you can see below I have set up public holidays so I should get 254 days and not 255.
It seems that Smartsheet is counting the first day of my duration, here 01/01/21 as a working day while it is considered as a public holiday. I tested to put the first monday of the year so Monday 4th of january, and when I do this I get the real result 254 days
Do you know if it is an error from duration calculation or should I change something ?
I tested this on a year period, but I have the same problem with other public holidays.
Thank you very much,
Corentin
Best Answer
-
Ok. That is expected then. Even if it is a holiday or weekend, if you have the start or end date as one of those dates it will override the "non-working day" status and assume that it is in fact a working day since it is being used as either a start or an end date.
Answers
-
Which function are you using to calculate?
-
Hello @Paul Newcome
I use the gantt project settings to calculate duration :
Let me know if you need more information,
Corentin
-
Ok. That is expected then. Even if it is a holiday or weekend, if you have the start or end date as one of those dates it will override the "non-working day" status and assume that it is in fact a working day since it is being used as either a start or an end date.
-
@Paul Newcome Thank you for your answer !
Corentin
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives