On Fri, 7 Oct 2005 12:10:47 -0500, comotoman
wrote:


cell a1: =today()

if a1 is 'October 7, 2005'

i need b1 to be '10/1/05'
b2: '10/2/05'
b3: '10/3/05'
etc......

Any ideas?

It's not clear how far you want your series to extend.

But to return the first of the month of the date in A1:

B1: =A1+1-DAY(A1)

then

B2: =B1+1
B3: =B2+1

etc.....

Format appropriately.

If you just want the current month in column B, change the formulas to
something like:

B2: =IF(ROW()=DAY($B$1+ROW()-1),$B$1+ROW()-1,"")

and copy/drag down to B31




--ron