I assume that in Col B you just want to fill in the dates from the start
of OCT (10/1) to the date in A1. With the formula "=Today()" in A1,
enter the following formula in B1: =EOMONTH(A1,-1)+1

In B2, enter this formula: =IF(B1<(A$1-1),B1+1,"") and then copy down
until the last cell you copy to appears blank. The blank cell contains
the formula but displays the null value ("") because it would be equal
to A1.

Hope this is what you wanted.


--
neopolitan


------------------------------------------------------------------------
neopolitan's Profile: http://www.excelforum.com/member.php...nfo&userid=611
View this thread: http://www.excelforum.com/showthread...hreadid=474230