Hi, Ron,
ok, with this formula, gets 11 Feb 2005, but this is right 180 days after 15
Aug 2004, isn't it?
I'm sure that you are right with the preference, but as Kit wrote 6 months
or 180 days...

Regards.

--
JRod
Microsoft MVP - Excel
http://EXCELer.blogspot.com

"Ron Rosenfeld" escreveu na mensagem
...
On Sun, 23 Oct 2005 15:56:21 +0100, "JRod" wrote:

Hi,
Perhaps this approach (took from another from Tom Ogilvy) has in
consideration month February (29 or 28 days):
=DATE(YEAR(A1);MONTH(A1);DAY(A1))+180+CHOOSE(WEE KDAY(DATE(YEAR(A1);MONTH(A1);DAY(A1)+180));1;0;0;0 ;0;0;-1)

Regards.

Have you tried it with other than an end of the month date?

For example:

A1: 15 Aug 2004 -- 11 Feb 2005

I would expect that the OP would prefer the result to be 15 Feb 2005.


--ron