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
@Ronal_bal did the workflow solution help you?