Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Break up a date range automatic
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Break up a date range automatic
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Break up a date range automatic
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Break up a date range automatic
Thanks for the info but it gives me every other day not everyday in the string
"Me" wrote: 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Break up a date range automatic
It works for me. Are you sure you copied it correctly?
Regards, Fred. "Cory" wrote in message ... Thanks for the info but it gives me every other day not everyday in the string "Me" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I remove the automatic break lines in text to columns? | Excel Discussion (Misc queries) | |||
Excel: How do you insert an automatic page break after each row? | Excel Discussion (Misc queries) | |||
Cannot move an automatic page break | Excel Discussion (Misc queries) | |||
Can I set an automatic page breaks to break every 40 lines? | Excel Discussion (Misc queries) | |||
How do I break a date range by month? | Excel Discussion (Misc queries) |