Kim,
He amended it quickly after. :)

Bob I wrote:
Oops, make that
=EOMONTH(A1,MOD(3-MONTH(A1),3))

--
--Thomas [PBD]
Working hard to make working easy.


"KIM W" wrote:

The brief formula below does not work-- it always returns end of Q1 even if
month is in Q2,3,or 4.

"Bob I" wrote:

=EOMONTH(A1,3-MONTH(A1))

Gerard wrote:

Is there a formula similiar to EOMONTH that can used to calculate the end of
a quarter?

For example, for a date of 5/28/08, is it possible to display 6/30/08, which
is quarter end?

If not any suggestions to an alternative formula (or string of formulas)?

MM/DD/YY format would be preferred.

Thanks in advance!