community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

1st working day of the month

Asteroid

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

Highlighted
Asteroid

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

Asteroid

@cpituley

 

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

Labels