On Oct 24, 10:38 am, gohar wrote:
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.

=eomonth(datevalue("5 march 2009"),0)

Of course, you can generalize the DATEVALUE() part to your heart's
content.