=INDEX({1;2;3;4},INT((MONTH(DATEVALUE(D2&" 1, "&YEAR(NOW())))+2)/3))

"eraasio" wrote:

Guys,

What I am trying to do is basd on the following column setup:
A B C D E
Supervisor Agent Month Score Quarter
John Doe Jane Smith September 96 3
John Doe Jane Smith December 99 4

I want to simply choose the month from from a list and have the Quarter
Column automatically choose the correct quarter.