while I don't think any method is truely perfect when dealing with dates. With my metod
This will fail on the 31st of just about any month, and especially in august, when 6 months prior is February...
There is no such date 2/31/2007..
closest date is 2/28/2007 - 3 days difference, so formula results in
I'll take that back, the Edate does work nicely.