excel date problem

S

Saiju Mammen

actually what i need is,in one excel cell i will be entering 15/8/05 and the
next cell i want to get the value as 30/8/06 ,that means next year same month
with end of month date
 
B

Biff

Hi!

A1 = 8/15/2005
B1 = formula:

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

August has 31 days!

Biff
 
B

Blue Hornet

Either that or:

=EOMonth( A1, 12) For this you need to have the Analysis Tool Pack
add-in activated.

Chris
 
Top