Thanks all for your suggestions ...
jer

"Arvi Laanemets" wrote:

Hi

MONTH(3)=MONTH("01/03/1900")=1
DAY(30)=DAY("01/30/1900")=30

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"jer" wrote in message
...
This may be very simple but the result is not what I expect, any help
suggestion would be greatly appreciated.

In cell a1 I have 10/15/2004
in cell b1 I put in the formula
=DATE(YEAR(A1)+1,MONTH(3),DAY(30))

I am expecting the result to be 03/30/2005, however the result I am
getting
is 01/30/2005.
Any suggestions
--
thanks as always for the help
jer