calcutale 2 date with round date

[Guest]

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

 

[joeu2004]

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.

 

[T. Valko]

With the date in A1:

A1 = 5 March 1984

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