Put this in B2...

=--LEFT(A2,FIND("-",A2&"-")-1)

Then put this in C2 and copy across to H2.

Note that this is keyed off of the first date only and will work correctly
even if only a single date (as opposed to your specified range) is placed in
A2.

Rick


"Cory" wrote in message
...
I want to be able to put a range of dates inot one cell (ie. 6/1-6/7) and I
want to able to have the individual days put into 7 differenent cells, 6/1
into b2. 6/2 into c2 ect