Date manipulation

[kolly]

I want to first of all thank Yard for his wonderful solution to my earlier problem. - Yard, you too much!
My question now is, If I have 03-March-2009 in cell D1 and D2 has the value 2, how can I add up D1 and D2 to produce 03-May-2009. I mean I want (03/03/2009)+2=03/05/2009, (02/04/2008)+5=02/09/2008, (25/10/2008)+7=25/05/2009, etc

 

[Dave Patton]

=date(year(d1),month(d1)+d2,day(d1))

 

[barry houdini]

If D1 is 31/08/2008 and D2 is 6 what should the answer be? Dave's formula will give 03/03/2009

This formula will give 28/02/2009

=EDATE(D1,D2)

although EDATE is an Analysis ToolPak function. To get the same result with native functions

=MIN(DATE(YEAR(D1),MONTH(D1)+D2+{0,1},DAY(D1)*{1,0}))

 

[kolly]

You guys are great. It worked.

Thank you