Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Working day exceptions
Is there a way to set up exceptions for working days? Lets say there will be a few weekends or a day that team would have to work during weekends.
Is there a way to set up these exceptions just like holidays are set?
Regards
Aider
Best Answer
-
Hi @Aider
There isn't a way to set the date as a "working day" opposite to a Holiday date, however you can use Elapsed Time to include weekends and holidays within a task. For example, instead of a duration of "2", you could put "e2" which will then include weekend days.
See: Work with Duration and Predecessors
Cheers,
Genevieve
Need more information? π | Help and Learning Center
γγγ«γ‘γ― (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!π | Global Discussions
Answers
-
Hi @Aider
There isn't a way to set the date as a "working day" opposite to a Holiday date, however you can use Elapsed Time to include weekends and holidays within a task. For example, instead of a duration of "2", you could put "e2" which will then include weekend days.
See: Work with Duration and Predecessors
Cheers,
Genevieve
Need more information? π | Help and Learning Center
γγγ«γ‘γ― (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!π | Global Discussions
-
Hello Genevieve
That was exactly what I was looking for, thanks!
-
@Genevieve P. Hi I tried this but it doesn't work for milestones, as I am unable to put e0. Any suggestions how to do this? I have a few milestone dates that fall over weekends and I need to show this on my plan.
-
Hi @aneekahTAL
Yes you're correct, elapsed time doesn't work with milestones as they have 0 time associated with that task in the Duration column.
If you don't have any Predecessors associated with that row, you can simply apply the correct date to the milestone so it falls on a weekend:
If you do need to use Predecessors, having the milestone start on a Friday will have it begin on the weekend:
Or you could add some lag time to the Predecessor to push it out to the end of the weekend:
I hope that helps!
Cheers,
Genevieve
Need more information? π | Help and Learning Center
γγγ«γ‘γ― (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!π | Global Discussions
-
@Genevieve P. Thanks for the feedback. Unfortunately it doesn't help as I need the date in the plan to show start on a weekend. i.e. start date must be Saturday. I'll figure something out that works for me.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.9K Get Help
- 441 Global Discussions
- 153 Industry Talk
- 500 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 78 Community Job Board
- 511 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I am trying to count the number of times "N/A" is included in a single row. I know it can been done with a single range with the below equation, but in this sheet there are some columns that want to eβ¦
- Hello! Long time listener, first time caller β We have a weekly update dashboard that is presented on Thursdays. We'd like to have the date displayed be either the previous weeks Thursday or the curreβ¦
- Can a JOIN function be used in a Sheet Summary to join two or more Sheet Summary Fields? I have two separate columns that I use a JOIN function for, but I'm not seeing how I can use it in Sheet Summarβ¦
