calcutale 2 date with round date

G

gohar

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
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top