thanks, i got it to work, needed =EndOfQuarter(a1), though.

i knew about where to put the code, just wasn't sure about the "function"
part of it. i have seen some work upon entry, but i guess this one didn't.
plus, i didn't know to enter =EndOfQuarter.

thanks, i learned something

--


Gary


"Myrna Larson" wrote in message
...
Go to the VB Editor, select your workbook in the project pane at the upper
left, and insert a Module into your workbook. Then paste the code into the
code pane that you see on right.

On the worksheet, with a data in A1, you write a formula like

=EOQuarter(A1)

and format the cell with a date format.


On Tue, 13 Sep 2005 13:49:19 -0400, "Gary Keramidas"

wrote:

just a question:
how do you get this to work? i wanted to test it but nothing happens when
i
make an entry