Do you mean you want the last date of the month for any date you put in A1,
or do you mean something else?
--
Regards,
Peo Sjoblom
http://nwexcelsolutions.com
wrote in message
oups.com...
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.