1st working day of the month

[AndrewCrayford]

I was wondering if it possible to work out the 1st working day of the month and also the 1st working day for the following month?

any advise or ideas would be great

[cpituley · Accepted solution]

Hi @AndrewCrayford, 

Please find attached an example workflow that will hopefully accomplish what you are looking for. 

I start with the first day of the month, check to see if it is a weekend, and then check to see if it is a holiday (manually maintained list of holidays - I used an Excel sheet but using text in the attached workflow). All the time moving forward by a day to ultimately get the first business day. 

Let me know if this is what you are looking for. Not the most elegant, but I think it works. 

Kind regards,

Cameron

[AndrewCrayford]

@cpituley

yes this is what i was looking for and many thanks for that