NetworkDays but using different days

Saleena Chiu

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.

 

Paul Newcome

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"?

Saleena Chiu

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.

 

Paul Newcome

How are you determining that they are taking those 3 days off? Where is that data entered?