Calculate based on no. of. days on a week

[Ronal_bal]

Hi,

I need to calculate the month based on the no. of days in a week.

Example:

We are good with week-2 of may since all the days inside the month of may.

But if you see the 5th of week of may where it has 3 days from May and first 2 days from June.

I want to consider the entire 5th week of may to assigned as month of may. 

So, the condition i require to use is whenever a week contains => 3 days from a month then it is assigned to the particular month.

Things to consider, the date field contains only the Monday of every week. So, with having only one date from a week we need to assign the month according to the above condition.

Can someone me help me here? Thanks in advance

[jdminton]

@Ronal_bal did the workflow solution help you?