Month to quarter

[Sech1]

I need help with finding a formula that gives med the quarter (1,2,3,4) from the month name (January, February...).
Anyone who can help me with this?

[samba_ravi]

if your Month name is in A1 TRY BELOW FORMULA

Please Login or Register  to view this content.

[Pete_UK]

You could do this:

=IFERROR(MOD(MATCH(A1,{"January","February", ... ,"December"},0)-1,3)+1,"")

you need to complete the list of months in the array.

Hope this helps.

Pete

[AlanY]

try this

=ROUNDUP(MONTH(1&A1)/3,0)