Hi C. O Jones
RE:Can't imagine why such frenzied postings have arisen about this.
Don't look at it this way, it's all about all of us sharing our thoughts and opinions and enjoying doing so!
I am not wishing for an agument here, but
"If one month is added to 28 Feb, what result would any normal person expect?
I think the expected result would be 31 Mar."
Is nothing more than a statement and conveys no logical offering at all.
"It seems to me that an end of a month is the last day of that month - can't really see how it can be something else."
It very much appears you have not read my previous response to this ie: I agree! But this grand statement has nothing to do with the debate. In other words it has nothing to do with taking 1 month from a starting month then one month of the resulting month and so on.. I feel this where you are both getting confused.
=EDATE("28/02/02",1) Results in 28/03/02 this is 28 days, the number of days in Feb
=EDATE("28/2/02",-1) Results in 28/01/02 this is 31 days, the number of days in Jan
It appears I may have typed the oppsosite before (my mistake)
.
The fact is, it works one way going forward (uses days in the Start month) and reverse (uses uses days in the resulting month) going backwards. This is Microsofts logic and makes sense to me, I fail to see how you cannot see this.
Using the last day of the month to say you MUST automatically go the last day of the next month might 'sound like the correct way' but it is not logical and thus cannot be used going backwards.
_________________
Kind Regards
Dave Hawley
OzGrid Business Applications
Microsoft Excel/VBA Training
This message was edited by Dave Hawley on 2002-03-29 22:16