nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!

Date Time

Accepted answers

Christina_H

I think this is what you need

Business days.yxmd

All comments

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.

Sample WF - Add 3 days.yxmd

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!

Sample WF.xlsx

tectonics25

Hi,

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

Book1.xlsx

Christina_H

I think this is what you need

Business days.yxmd

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.

Sample WF - Add 3 days Min Date.yxmd

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.

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15905

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703