dates and drop down lst

[bluepenink]

hello

having some issues with showing two dates side by side in a drop down list through data validation.

basically i have a every monday start date and end of the week date
so i want the drop down to look like this (see below)...going all the way down to 2012

6-June-2011 to 12-June-2011

i cant make it work :S..can someone pls help!

 

[Barbara Excel]

Hi

try using a custom list. The list can be set up on the sheet that will contain the drop down lists, or on a different sheet.


1. Type the list of items you want in a single column or row- just enter your date ranges
2 Next, name the List Range, do this by selecting/highlighting the cells in the list. Click on the Name box to the left of the formula bar and type a one word name then press enter
3.Thirdly, apply your Data Validation. Select the cells you want to apply the data validation. From the Data menu select Validation. From the Allow drop down list select List.
4. In the Source box, this is where you reference the named range, so type an equal sign and then the list name, the click Ok.

hope that helps

Barbara Excel

 

[bluepenink]

I tried that earlier dude

it has to be a single column or delimited.

when it crosses over multiple columns, it messes things up

i.e.
A1 = 6-June
B1 = to
C1 = 12-June

I defined that range A1:C1 as NewWeek

so i went into data validation > list > source: =NewWeek

and it says...it ahs to be delimited, or single row/column

help!

 

[snoopyhr]

Give this a try :

Excel Workbook
	A	B	C	D	E
1	Start	End	Combined	*	2 options for DV
2	6/6/2011	6/11/2011	06/06/2011 To 06/11/2011	*	06/27/2011 To 07/02/2011
3	6/13/2011	6/18/2011	06/13/2011 To 06/18/2011	*	*
4	6/20/2011	6/25/2011	06/20/2011 To 06/25/2011	*	*
5	6/27/2011	7/2/2011	06/27/2011 To 07/02/2011	*	06/27/2011 To 07/02/2011
6	7/4/2011	7/9/2011	07/04/2011 To 07/09/2011	*	*
7	7/11/2011	7/16/2011	07/11/2011 To 07/16/2011	*	*
8	7/18/2011	7/23/2011	07/18/2011 To 07/23/2011	*	*
9	7/25/2011	7/30/2011	07/25/2011 To 07/30/2011	*	*
10	8/1/2011	8/6/2011	08/01/2011 To 08/06/2011	*	*
11	8/8/2011	8/13/2011	08/08/2011 To 08/13/2011	*	*
12	8/15/2011	8/20/2011	08/15/2011 To 08/20/2011	*	*
13	8/22/2011	8/27/2011	08/22/2011 To 08/27/2011	*	*
14	8/29/2011	9/3/2011	08/29/2011 To 09/03/2011	*	*
15	9/5/2011	9/10/2011	09/05/2011 To 09/10/2011	*	*
16	9/12/2011	9/17/2011	09/12/2011 To 09/17/2011	*	*
Sheet1

#VALUE!

</td></tr></table></td></tr></table>

For sure there are better ways doing it with VBA but not me ....