-
NETWORKDAYS formula
I am trying to calculate days open between the request date and today and not count weekends however I want the count to start at 0, not 1. I am using the below formula but for everything with today as the request date, it is showing -2. Once it moves to tomorrow, the days open goes back to 1. How do I get rid of the -2?…
-
Networkdays formula between today and go live date
Hi, I would like a formula to calculate the number of network days between todays date and a go live date and return a negative if go live is in past and positive if go live is in future eg todays date 24/03/25, (go live date) 29/03/25 = 5 days Here is the formula im currently using =TODAY() - [Requested Go-Live]@row on my…
-
How to fix adding 1 or -1 to date difference calculations
Hello, I'm trying to set up a formula which will calculate the difference between two dates to achieve a days overdue number for our orders. Current formula is: =IF(Status@row = "Delivered", NETWORKDAYS([Delivery Date Expected]@row, [Delivered Date]@row)) This is returning an almost correct result, except it always adds a…
-
Due Date based off a workday schedule - Need Workday Formula Help
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 need to be opened -1 to the start of a new month. But this needs to be a workday. I have been trying to setup the formula so…
-
Networkdays.Intl
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 dependency function is not helping that way, as the start date has alwasy to be in the past.
-
Why is December's NETWORKDAYS formula not calculating correctly?
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?
-
IFERROR and NETWORKDAY formula
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 source sheet to find the number of working days between the two dates: =IFERROR(NETWORKDAYS([SourcesheetRange1],…
-
Days to go formula
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 but gives a negative number. If the date is 5 days in the future I'd like it to read 5 not -5. If in the past be negative,…
-
Networkdays formula syntax error
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 the provided formula, which works in the cell I place it in, I get a syntax error. I can't figure out the error.
-
This Month's/Year's Net Work Days As Of TODAY
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" remaining work days? So the August 2024 answer would be 18 as of today, September 2024 would be all 20 remaining work days, October…
