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?


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=474230

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

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