=ROW(1:1), or =ROW(1:65536) for that matter, returns the row number of the
first referenced row (in this case 1). It is similar to other references in
excel in that it can be relative as in ROW(1:1) or absolute as in
ROW($1:$1) - which will not change if copied elsewhere.

Copying ROW(1:1) down just moves the original reference like copying any
other relative reference formula down. Copying down one row will give
ROW(2:2), copying it down 4 rows will give ROW(5:5). Any of these just
returns the row number of the first row, so it can be used to create arrays
of consecutive integers (between 1 and 65536, but you could always add or
subtract from the row number this returns, if you needed integers beyond
this range).




"Dkline" wrote in message
...
Your answer works but I'm not entirely sure why. How does the Row(1:1)
work?
This creates an array of consecutive integers?


"Dave R." wrote in message
...
A simplified formula would be:

=EDATE($A$1,1)

If you want to use that for a range of dates, try

=EDATE($A$1,ROW(1:1)) and copy down.