View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael[_4_] Michael[_4_] is offline
external usenet poster
 
Posts: 27
Default End of Quarter Based on Fiscal Year

I am trying to come up with a fuction that takes a date and depending
on the month that the fiscal year ends return the last day of the
quarter. For example date 12/21/2011 on a fiscal year that ends Oct 31
would return 1/31/2012.

Basicly I am trying to round dates up to the date at the end of the
fiscal quarter it falls in.

any help would be appreciated