Thread
:
Quarter End Date
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
[email protected]
Posts: n/a
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.
Reply With Quote