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