With the date in A1:

A1 = 5 March 1984

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

--
Biff
Microsoft Excel MVP


"gohar" wrote in message
...
i want a calculate 2 different date
eg. date of birth is 5 march 1984
if i add 25 years , it will be 5 march 2009
i want a result 31 march 2009.
thank you