-
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…
-
NETWORKDAYS between a date and a number
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 in the Due Date column =[Due Date]9 - 180 (works fine, and gives me the result of a date based on the cell [Due Date]9 minus…
-
How to calculate using a 7 day workweek (to replace NETWORKDAY)?
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 week. I am now being asked to count using 7 days per week. Is there a comparable function that I can swap out for…
-
Define workdays by row
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 week and need to define on a row level, not a sheet level.
-
Count # of networkdays if a condition is not met
Hello, I want a formula to count the number of workdays between when an item was assigned only if a condition is not met. =IF(Request Status - Contracting]@row <> "Contract work Complete", [Date Assigned to CM]@row, TODAY()) I want the # of days counted since an item was assigned to a manager only if the manager has not…
