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(WEEKD AY(DATE(YEAR(A1);MONTH(A1);DAY(A1)+180));1;0;0;0;0 ;0;-1)

Regards.

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

"FxM" escreveu na mensagem
...
kit wrote:
Hi
have the following date format in A1 - 12/15/05.
In b1 I want the date calculated as 6 months later, entered the following
in b1-
=DATE(,,A1+180), but it returns #NUM. Tried it as +6 but still same
result
What am I doing wrong

Hi kit,

Try =date(year(A1),month(A1)+6,day(A1))

Be careful concerning :
* 6 months < 180 days
* 31 aug + 6 months is not 31 feb :o)

FxM