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.
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…
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…
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…
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.
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…