I NEED A FORMULA THAT TAKES THE DATE AND CONVERT IT IN A QUARTER
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)
"jcm" wrote in message
...
I DEVELOP A MODEL, I NEED TO TAKE A DATE AND CONVERT IT IN QUARTER
|