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(WEEK DAY(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