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!
Solved! Go to Solution.
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.
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
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.
Thank you! yes, that's exactly what i needed.
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.