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

  • Thread starter Thread starter jcm
  • Start date Start date
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)
 
Back
Top