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