On Apr 1, 8:11*am, joeu2004 wrote:
As for propagating down the column, that depends on how
many dates you have to enter. *The following are 2 ways.

I forgot to mention a 3rd way, albeit not as easy.

3. Enter 1/1/2010 into A1. Enter =EDATE(A1,1) into A2.
Alternatively, enter =DATE(YEAR(A1),1+MONTH(A1),1) into A2.
Copy A2.
Paste into the reminder of the column, either by selecting the
intended range starting with A3, or by entering the remaining range
into the Name Box, e.g. A3:A100.

In XL2003 or earlier, if you used EDATE and get a #NAME error, simply
use the DATE alternative or go to the EDATE help page for instructions
regarding the ATP.