NetworkDays but using different days
Hello,
I am trying to creating a PTO form but we have users that work weekends. In Excel, there is a formula, NETWORKDAYS.INTL (start_date, end_date, [weekend], [holidays]), that allows to shift what is considered a non-countable workday.
Is there a formula or a workaround for this formula?
Note: This is not a Gantt sheet so the global fix of what is considered a workday does not apply.
Thank you.
Comments
-
What is your end goal for this data? Can you provide more details and possibly some screenshots with sensitive/confidential data hidden or replaced with "dummy data"?
-
I have 3 columns: Start Date, End Date, and Calculated Number of Days.
Example: A user's work week is Saturday-Thursday instead of Monday-Friday. User is taking Saturday, Monday, Tuesday off. Right now, the formula NetworkDays shows that the user is taking 2 days off instead of the 3 days.
-
How are you determining that they are taking those 3 days off? Where is that data entered?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!