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

Not really. Trying to write a generalizable formula to find the
nearest month, quarter, half-year, or year-end, but able to accomodate
different fiscal year start dates.

For example, if the Fiscal Year begins in November and today's date is
today, 4/6/06.

Nearest month end: 4/30/06
Nearest quarter end: 4/30/06
Nearest half-year end: 4/30/06
Nearest year-end: 10/31/06

If the fiscal year began in January, then it would be:

Nearest month end: 4/30/06
Nearest quarter end: 6/30/06
Nearest half-year end: 6/30/06
Nearest year-end: 12/31/06