actually what i need is,in one excel cell i will be entering 15/8/05 and the
next cell i want to get the value as 30/8/06 ,that means next year same month
with end of month date

Hi!

A1 = 8/15/2005
B1 = formula:

=DATE(YEAR(A1)+1,MONTH(A1)+1,0)

August has 31 days!

Biff

"Saiju Mammen" <Saiju wrote in message
...
actually what i need is,in one excel cell i will be entering 15/8/05 and
the
next cell i want to get the value as 30/8/06 ,that means next year same
month
with end of month date

Either that or:

=EOMonth( A1, 12) For this you need to have the Analysis Tool Pack
add-in activated.

Chris