Formula for adding the last 3 business days of each month to the next month

[tectonics25]

Hello,

I need to calculate the last 3 business days of each month, and add them to the next month (like 11/30 become 12/3, but business day without counting weekends) , for a column with a variety of previous dates. would you please help me with the formula?

Thanks!

[PanPP]

Hi @tectonics25 

I have uploaded a sample workflow that adds 3 days to the last 3 business days of the month resulting in the next 3 business days.

2022-12-28 --> 2023-01-02 (Monday)
2022-12-29 --> 2023-01-03 (Tuesday)
2022-12-30 --> 2023-01-04 (Wednesday)
2023-01-27 --> 2023-02-01 (Wednesday)
2023-01-30 --> 2023-02-02 (Thursday)
2023-01-31 --> 2023-02-03 (Friday)

Hope this helps. If it does, please like this post and mark it as a solution.

[ShankerV]

Hi @tectonics25 

I got your question, but its too generic.

If you are able to share the sample input and expected output, will be more easy to work on the expected solution which can be inherited in your workflow.

Many thanks

Shanker V

[tectonics25]

Hi and thank you so much for your help, but unfortunately that's not my solution. maybe i explained it wrong, but the attached will show you what i need to have. and also, your output narrow down to 12 at the end, i need to have them all. thanks again!

[tectonics25]

Hi,

sure, here is a sample. and thank you so much!

[Christina_H · Accepted solution]

I think this is what you need

[PanPP]

Hi @tectonics25 

I have uploaded a new WF that extracts the dates you prefer.

Hope this helps. If it does, please like this post and mark it as a solution.

[tectonics25]

Thank you! yes, that's exactly what i needed.

[tectonics25]

Thank you! it is somehow what i need, except the last part i believe i need to join the final result, with my original data. because it only shows the ones that falls into the last 3 months of each month. I still need to see the ones that falls into different days of month and didn't need to be changed, as well.