Assign Number to A ranges of Dates

Hi,

You can give a try to MONTH() function in if else logic .
It will solve your problem.

Thanks,
Anurag