Week counter

[EmilijaN]

Hello, 

I need help with creating a code to find how many days of the weeks belong to One or another Month.

Example:

                                                        New column

1/31/2022 January    week day 1      Feb
2/1/2022   February  week day 2      Feb
2/2/2022   February  week day 3      Feb
2/3/2022   February  week day 4      Feb
2/4/2022   February  week day 5      Feb
2/5/2022   February  week day 6      Feb
2/6/2022   February  week day 7      Feb

If there is more than 4 days in the same Month than all that week I need to be in that Month. In the example all this days have to be in February .

Any suggestions?

[EmilijaN]

The month that has it more times in a week always wins.  Then the output will be January for whole week.

[ryan_mayu]

pls check if this is what you want

[ryan_mayu]

what if no more than 4 days? what's the output for the first row?