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
|