Copy down unique date formula

[benfitz]

I want to copy a formula down. The data is dates between 02/01/2009 and 14/12/2009 but only want every Wednesday and Saturday. I have put in the first few and trie to copy the formula down but excel just copies the five or so I have put in and pastes that over and over again.

Is what I am trying to do possible and if so how?

 

[scottylad2]

I've created some random dates and the formula i put in seems to work I've added and formatted the cells in column K for info only

Excel Workbook
	I	J	K
4	25/06/2009
5	03/12/2009
6	28/03/2009	28/03/2009	Sat
7	14/06/2009
8	09/08/2009
9	02/11/2009
10	05/03/2009
11	07/12/2009
12	10/03/2009
13	09/11/2009
14	15/05/2009
15	02/08/2009
16	08/04/2009	08/04/2009	Wed
17	28/11/2009	28/11/2009	Sat
18	16/05/2009	16/05/2009	Sat
19	28/05/2009
20	11/07/2009	11/07/2009	Sat
21	21/09/2009
22	25/06/2009
23	08/03/2009
Sheet5

 

[scottylad2]

I just tried my formula with your date range and it works just fine.......but too large to display on here

 

[scottylad2]

One way to do it, is list all the dates in A:1 and copy down your dates then apply my formula in B1 and copy it down the whole row. next in C1 do =B1 and copy down also and while the column is still highlighted, click on ctrl 1 and open the format menu. Click on Custom and in the box type ddd then ok You should now have the dates in col B and the dates formatted as Sat or Wed in col C. Go to the Data menu, then click on Filter, you will have various dates in there and als a check box for blanks. untick that, and your list will now only be sats and weds....copy and paste to a new location and you'll have your list of weds and sats

 

[benfitz]

Thank for the help. That worked great. My only problem is I have many entries for each day. How can I filter these further to erase the duplicates and only get one of each wed and sat.

 

[Aladin Akyurek]

Thank for the help. That worked great. My only problem is I have many entries for each day. How can I filter these further to erase the duplicates and only get one of each wed and sat.

One way: Advanced Filter with the Unique records oly option checked.