I need a formula to find the last day of last month, no matter what day it is in the current month.
Example, if today is May 10, I need to return April 30th. If today is May 15, I need to return April 30th. If today is June 30, I need to return May 31.
I guess at some level I have to be concerned about February and Leap years, but for this purpose, I can work around that by always finding the 28th?
Additionally, I’d like to find the last day of the month two months before and 3 months before.
Thanks for any help!