Quarter date format
 

No, because there isn't a standard definition for quarter.

--
Regards,
Tom Ogilvy

"Alberto Tejada" wrote in message
...
I'm working with dates and I want to know which quarter
the date belongs to.
Is there a date format to see the quarter?

Quarter date format
 

for calandar year end use:

=INT((MONTH(B2)-1)/3)+1

for fiscal year end:

=MOD(CEILING(22+MONTH(B2)-9-1,3)/3,4)+1

assuming fiscal year end is Septemer = 9 in the formula, change th
ending month number to fit your's need

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com