Will:
I found this in Microsoft 2000 Formulas:
=ROUNDUP(MONTH(celladress)/3,0)

I use it in my spreadseets and it works very well, if you are looking
for a simple function to determine a months quarter.

Bobbie

Clueless in Seattle wrote:
> I recently switched from Excel 97 to Excel 2003
>
> Today I tried to use Excel 2003 to enter data into a worksheet I
> originally created with Word 97.
>
> One of the columns in the original worksheet contains the formula
> =QuarterNum(cell reference)
>
> Under Excel 97 this formula would display the quarter number for a date
> entered into the referenced cell.
>
> But under Excel 2003 it displays ####.
>
> When I place the cursor over the cell a tan colored box pops up
> displaying #NAME? And when I click on the cell a white box containing
> an exclmation point inside a diamond shape pops up to the left of the
> cell.
>
> I seem to recall having to go monkey around with Excel 97 to get the
> =QuarterNum() formula to work, but I'm afraid my memory doesn't server
> me very well these days and I'm not able to remember how I got it to
> work. I searched this newsgroup for "Quarter Number" and "QuarterNum"
> but got no hits.
>
> I'd be grateful to someone who would be willing to help me out with
> this.
>
> Will in Seattle
> a.k.a. "Clueless"