networkdays
Discussion List
- Hello everyone. I'm trying to use a WORKDAY formula to auto-update a list of due dates. We have several financial tasks that must be completed a specific workday every month. For example, the books ne…
- Like excel, to calcutlate the workdays of countris follwing different patterns of weekend, we need to enable the formula for networkdays.intl. In smartsheet we don't have that one as of now, and the d…
- Hi - I have this formula that works perfectly for the year, but when I get to December it is calculating an odd negative number. Can anyone help me understand why and what I need to do to correct it?
- Hi, I have a source sheet with two date columns: Date of Request and Date of Completion. I am using a summary sheet to create a dashboard and have used this column formula to cross reference the sourc…
- I have a dedicated column "days to go" I'm trying to get the formula to take the networkdays between today and the start date (accounting for dates in the "holiday helper" column. This formula works b…
- I used the AI formula builder to create a formula to calculate the number weeks (weeks out) between a launch date and milestone dates. I want the weeks out to always be positive. When I try to convert…
- So, August 2024 has 22 Net Work Days. But as of today (08/07/2024), there are only 18 Net Work Days remaining in August. Is there a formula I can create that will show me "X Month's/X Year's" remainin…
- How does it work to minus a number of days from a date cell using networkdays? One column is a Due Date that I would like to populate based on a set date that will be static in [Due Date]9 cell I put …
- I am using this formula to calculate the # of days it takes to get to a particular task called, Enable. Range 2 = %Complete and Range 1 = Start Date of Enable. It calculates correctly using 5 days per…
- Excel has a new formula in which you can define workdays by row (workday.intl). I am having to switch to Excel just for this function as I have different shifts working different number of days per we…