If Then Function Help needed

[wheatgrass]

If column F date entered falls between below listed months, then Colum G shows appropriate quarter.

Column F: = Date of Consult: Column G: = Quarter:
if date entered is between month of October - December then quarter =1
if date entered is between months of January - March then quarter =2
if date entered is between months of April - June then quarter =3
if date entered is between months of July - September then quarter =4


Dates entered will be in format of mm/dd/yy

Thanks.

[ConneXionLost]

Hi,

Give this a try:

=LOOKUP(MONTH(F2),{1,4,7,10},{2,3,4,1})

Cheers,

[dilipandey]

Hi WheatGrass,

You can use the following formula:-

=IF(AND(MONTH(G8)>=10,MONTH(G8)<=12),1,IF(AND(MONTH(G8)>=1,MONTH(G8)<=3),2,IF(AND(MONTH(G8)>=4,MONTH(G8)<=6),3,4)))

where G8 is the date for which you need to find the quarter.

Regards,
DILIPandey

<click on below 'star' if this helps>