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