calcutale 2 date with round date

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
Click to expand...

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

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