Put the date range in A2:
6/1/2008-6/7/2008




Put this formula in B2 and copy to each cell to H2:
=MID($A2,1,SEARCH("-",$A2)-1)+COLUMN()-2



Since you said "7" cells I assume this will alway be a 7 day week. You
actually only need the first date, which this formula extracts from the text
6/01/2008-6/7/2008.

Don

"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