Sign in to join the conversation:
Greetings,
I have the start day and the duration. Is it possible to calculate the end date using these two entitites such that only working days are included (only monday through friday and not the weekends)?
Thank you
I would take a look at the WORKDAY function.
WORKDAY()
WORKDAY(date, num_days, [holidays])
Used in a Date column to return a date from a specified number of working days. Optionally excludes holidays outlined in a range.
Hmmm. You might also try turning on dependencies. It will set up a start time and a finish time column if you don't already have one and calculate the finish time for you. When you edit the start date or the duration, the end date will calculate for you automatically.
That might be a better way of doing it rather than using custom formulas.
Another added benefit of turning on dependencies is that you can also make the end of one task determine the beginning of the next one.
Thank you very much.
It worked!
Happy to help!
I would also suggest looking into dependencies as Mike suggested below. I don't use them for various reasons, so I never think about them as a solution.
Can this be done without using a function?
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
Currently Triggering recurring workflows are only supported at the top of each hour. For instance 10:00, or 11:00, etc. Would like the ability to set 10:30 or 10:45. Perhaps the inteface can stay hourly so it doesnt get huge, but have the ability to manually edit the time directly to any custom time.
I have an automation that has a condition where I am looking at the column "LEA Interco Supporting Site(s)" and trying to find columns that have the value "Fort Loramie" in them. This works well when "Fort Loramie" is the first item listed in the cell, but it doesn't work when "Fort Loramie" is the second or third value in…
