calcutale 2 date with round date
 

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

calcutale 2 date with round date
 

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.

calcutale 2 date with round date
 

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