You can also use the DAY function to feed a day value into another...

The Excel MONTH function returns the month portion of a date as number between 1 to 12 when given a date.

The Excel DAY function returns the day of the month as a number between 1 to 31 when given a date.

Allen Wyatt With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. Automate virtually any routine task and save yourself hours, days, maybe even weeks.

He is president of Sharon Parq Associates, a computer and publishing services company. Then, learn how to make Excel do things you thought were simply impossible!

Next, a new date is assembled by the DATE function, using the same day and year, and month 1 for month.

The first formula therefore returns a new date of 2/15/2010, one month later than the starting date.

If you need a series of dates where every date is the last day of the month you can use EODATE like this: If you need to generate a dynamic series of dates with a formula that increase by one day from a single start date, you can do so a very simple formula that simply adds 1 to each date.

How the formula works In the example, B6 is the hard-coded start...

Interestingly enough, Excel has a quirk that you can exploit when doing your filling.

If you put a 1 into cell A1, select that cell, and drag downward, Excel assumes that you want to fill each cell with the number 1.

You can use the MONTH function to extract a month number from a date into a cell.

You can also use the MONTH function to feed a month number...

Bill noted that he can use the fill handle to fill a range of cells with values, such as 1, 2, 3, 4, etc.