date function

[Badnames]

I want to add one month to a date I have existing already and leave the day number and year the same.

Lets say I have date (say cell B1) 7/1/2011 I want the next cell to be (c1) 8/1/2011, then 9/1/2011 and so on.

I need it to be a formula, so I can switch the amount of months. So if i want I can change the number to 10 and it will count every 10th month.

I tried using the date functon, but that did not work. I used c1=date(B$1,B$1+1,B$1), date being date(year,month,day).

Is there another function i could try or a creative way to tackle this problem?

 

[Jonmo1]

Try this

=EDATE(B1,1)

this requires the Analysis toolpack from Tools - Addins

 

[njimack]

=Date(YEAR(B1),MONTH(B1)+1,DAY(B1))

 

[Scott Huish]

How you approach this depends on what you really want.

If you're start date is 1/31/2011, there is no 2/31/2011, or do you're dates always start with the 1st?

 

[Badnames]

Thanks guys. njimack thats the function I was looking for. Used to do it, but I forgot how. Thanks a bunch.

 

[njimack]

glad it worked, thanks for the feedback.