If Then Function Help needed

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.

Hi,

Give this a try:

Please Login or Register  to view this content.

Cheers,

Hi WheatGrass,

You can use the following formula:-

Please Login or Register  to view this content.

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

Regards,
DILIPandey

<click on below 'star' if this helps>