Calculate Quarter end?
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!
|