Reply to thread

Message

[QUOTE="brettopp, post: 3737756"]
I was reading an Excel book on Friday and even the author was commenting on
how difficult working with dates in Excel can be.

The formula below works more consistently than any other I have tried, but
Excel still yields uneven results.  Entering the end date as the 30th of the
month for all months with 31 days in them, here is what the formula yielded:

User-entered end date    Formula Start Date
1) Jan-30-2008	        Dec-31-2007
2) Mar-30-2008	        Mar-02-2008
3) May-30-2008	        May-01-2008
4) Jul-30-2008	        Jul-01-2008
5) Aug-30-2008	        Jul-31-2008
6) Oct-30-2008	        Oct-01-2008
7) Dec-30-2008	        Dec-01-2008

Below are the results I was looking for, for the one item above that did not
yield the correct results via the formula:

User-entered end date    Formula Start Date
2) Mar-30-2008	        Mar-01-2008

I don't know that it is possible to get better results outside of setting up
a complex table, so I will gladly go with the formula that you provided.
Thank you!
[/QUOTE]

Verification