View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gerard Gerard is offline
external usenet poster
 
Posts: 19
Default Calculate Quarter end?

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!