I NEED A FORMULA THAT TAKES THE DATE AND CONVERT IT IN A QUARTER

[jcm]

I DEVELOP A MODEL, I NEED TO TAKE A DATE AND CONVERT IT IN QUARTER

 

[Ron Coderre]

With
A1: (a date)

This formula returns the quarter number (1,2,3, or 4):
=CEILING(MONTH(A1)/3,1)

Also: Please don't type in all capital letters...it's painful to read.
(It also means you're yelling)

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)