Question

Can I ignore weekends when calculating a date?

  • 31 May 2023
  • 1 reply
  • 319 views

I am making a workflow that tracks milestones before a project due date. The project due date could be any weekday, M-F. For example the input would be the project due date (ex Tuesday) and the task has to happen 3 business days before (ex Thursday). When I do a calculation of -3 days, it gives me Saturday. 

 

Here are the results I want. Anyone have ideas how to make this happen?

 

Project Due Date (input) - Monday

Task Due (output) - Wednesday prior

 

Project Due Date (input) - Tuesday

Task Due (output) - Thursday prior

 

Project Due Date (input) - Wednesday

Task Due (output) - Friday prior

 

Project Due Date (input) - Thursday

Task Due (output) - Monday prior

 

Project Due Date (input) - Friday

Task Due (output) - Tuesday prior


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @Paula B 

Good question.

Try using Formatter steps.

  • Action: Formatter > Utilities > Lookup Table
    • Configure to return the number of days delta to use
    • e.g. If Date is a Tuesday, then return -5
  • Action: Formatter > Date / Time > Add/Subtract Time