Formula to assign value on first working day of month

[DataIsFun]

Hi Everyone,

I'm currently struggling to put a formula together that will assign a value to my data based on the day and time my WF is executed. Essentially on the first working day of the month i.e. 2022-12-01 for December I need to assign the value completed if the wf is run between 09:00:00 and 10:00:00.

I hope this makes sense as my English is sometimes not the best.

Many thanks to anyone who takes the time to reply in advance. 

[ShankerV]

Hi @DataIsFun 

Can you please explain in Input, Logic to be applied and Output expected.

So that its easy for me to get the output, by building the workflow.

Many thanks

Shanker V

[DataIsFun]

@ShankerV currently I have 5 separate formulas to calculate the deadlines but it's not robust enough as it doesn't assign a value So I essentially would like to be able to use one formula instead of 5  

[DavidSkaife · Accepted solution]

Hi @DataIsFun 

Here is a workflow that you can use to incorporate into your existing, which works out if the first day of the month is a working day, and if the workflow has ran between 9 and 10:

First Formula tool works out the first date in the month for your 'Enddate', and also what day of the week it is.

Next it filters on the day being Sat or Sun, if this is false then it performs the following checks; does the 'Enddate' equal the 'First of the Month' date, is the time now (i.e when the workflow is ran) between 09:00:00 and 10:00:00, and finally creates an output field of Completed if it passes both these checks.

If the Day is a Sat or a Sun then it adds 2 or 1 day to the 'First of Month' and performs the same checks as above

Hope this helps and you can incorporate it into your workflow - let me know if you have any questions!