View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Quarter End Date

Is there a way to generalize for any fiscal month start using the
following formula:

DATE(YEAR(A1),CEILING(MONTH(A1),3)+1,DAY(0))

This I find to be best because it can be used to find half-year and
year-end intervals as well.