Increase month instead of day when drag down a cell with date content

[html]

Hi!
I just wonder how I can drag down a cell containing a date, and instead of increasing the day, I want to increase the month?
Exsample:
First date: 15.08.2015 (that is fiftenth of August 2015). I want to drag this Down to the cell below, but instead of increasing to 16.08.2015, I want it to be 15.09.2015, and next 15.10.2015 and so on. Is this possible in any way?

Kind regards,
Trond Martin!

[Ron Coderre]

Try these examples:
A1: 15-Aug-2015

• Select A1:A100
• Home.Fill.Series...Check: Month...Click: OK

OR
• Select A1
• Home.Fill.Series
...Check: Column
...Check: Month
...Enter an end date....15/12/2030
...Click: OK

Is that something you can work with?

[FDibbins]

Hi, welcome to the forum

Ron's suggestion should work for you...What you need to understand about dates and times in excel is...

a date is just a number representing the number of days passed since 1/1/900...and then formated in a way that we recognise as a date. So, for instance, today (Sun Jul 2015) is actually 42197

Time is actually a decimal part of 1 (day), so 06:00 AM is 0.25, 12 noon is 0.5 and 18:00 (or 6 PM) is 0.75

So when you drag 15/08/2015 down, what you are really doing is what is showm in column H below...

	G	H
1	Date Format	General Format
2	15.08.2015	42231
3	16.08.2015	42232
4	17.08.2015	42233
5	18.08.2015	42234
6	19.08.2015	42235

[Tony Valko]

Another way...

Enter the first 2 dates in the series...

A1 = 15.08.2015
A2 = 15.09.2015

Select A1:A2 and drag down as needed.

[html]

Thank you, yes that worked perfectly, smart and easy.
Thanks for quick help and new Learning.

Have a nice summer!

Kind regards,
Trond Martin!

[html]

Yes, this Works too, faboulous! Thank you!

Kind regards
Trond Martin!

[html]

Thanks all for good answers!

Have a happy summer!

Kind regards
Trond Martin!

[Tony Valko]

You're welcome. We appreciate the feedback!

[FDibbins]

Thanks for the feedback