Break up a date range automatic

[Cory]

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

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Me]

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]

Thanks for the info but it gives me every other day not everyday in the string

 

[Fred Smith]

It works for me. Are you sure you copied it correctly?

Regards,
Fred.