The easiest way is to use the EDATE function, for which you need
Analysis ToolPak enabled

in A1

=EDATE(TODAY(),1)

in A2 copied down

=EDATE(A1,1)

note that with EDATE if today is 31st March EDATE(TODAY(),1) will give
30th April


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=509608