On Sun, 23 Oct 2005 18:25:12 +0100, "JRod" wrote:

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

Maybe it's the English language, but when I the OP wrote:

In b1 I want the date calculated as 6 months later

That's what I assumed. The 180 reference I saw in his post I interpreted as
being part of his initial attempt to achieve his requirement.


--ron