Gerard,

Here is a pretty long nested if, but it will do what you want. Someone
might have a better idea than this:

=IF(A1DATE(YEAR(A1),3,31),IF(A1DATE(YEAR(A1),6,3 0),IF(A1DATE(YEAR(A1),9,30),DATE(YEAR(A1),12,31), DATE(YEAR(A1),9,30)),DATE(YEAR(A1),6,30)),DATE(YEA R(A1),3,31))

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


"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!