On Tue, 21 Jun 2005 01:53:34 -0700, "Pank"
wrote:

How can enter effectively enter a formula in a macro which is along the
lines of ((current month – 1)/3)). If current month – 1 = 0 then set current
month to 12 and undertake the calculation again.


Qrtr = DatePart("q", DateAdd("m", -1, Date))

Lastly, if my version of Excel is 2000, should I substitute 2000 in place of
9795 in the file format above?

I do not see that as an available choice in XL2002, so I would guess not.



--ron