Return date of Friday of each week from a range of dates

[emortals]

Hello,

I have worksheet called "daterange", In column B:B it has a sorted range of dates in dd/mm/yyyy, many of which are duplicates. I would like for excel to look through the range and return only the date which is a Friday, somehow it should ignore the duplicates. I want the below results to be copied to a different worksheet, lets call that "output" and in column A1 going down.

For example, if we are looking at the range of dates for December 2014, the results should look like this:

5/12/2014
12/12/2014
19/12/2014
26/12/2014

Please let me know if you need any further information.

Thanks,
emortals

[FDibbins]

I would do this with a helper column to ID the dates to use...

	A	B	C	D
2	Monday, December 1, 2014			Friday, December 5, 2014
3	Tuesday, December 2, 2014			Friday, December 12, 2014
4	Wednesday, December 3, 2014			Friday, December 19, 2014
5	Thursday, December 4, 2014			Friday, December 26, 2014
6	Friday, December 5, 2014	12/5/2014
7	Saturday, December 6, 2014
8	Sunday, December 7, 2014
9	Monday, December 8, 2014
10	Tuesday, December 9, 2014
11	Wednesday, December 10, 2014
12	Thursday, December 11, 2014
13	Friday, December 12, 2014	12/12/2014
14	Saturday, December 13, 2014
15	Sunday, December 14, 2014
16	Monday, December 15, 2014
17	Tuesday, December 16, 2014
18	Wednesday, December 17, 2014
19	Wednesday, December 17, 2014
20	Friday, December 19, 2014	12/19/2014
21	Saturday, December 20, 2014
22	Monday, December 22, 2014
23	Monday, December 22, 2014
24	Tuesday, December 23, 2014
25	Wednesday, December 24, 2014
26	Thursday, December 25, 2014
27	Friday, December 26, 2014	12/26/2014
28	Saturday, December 27, 2014
29	Sunday, December 28, 2014
30	Monday, December 29, 2014
31	Tuesday, December 30, 2014
32	Wednesday, December 31, 2014

B2=IF(OR(COUNTIF($A$2:A2,A2)>1,WEEKDAY(A2,2)<>5),"",A2)

Then to extract the dates...
D2=IFERROR(INDEX($B$2:$B$32,MATCH(0,INDEX(COUNTIF($D$1:D1,$B$2:$B$32),),0)),"")
This could be put on a different sheet if needed

[emortals]

I would do this with a helper column to ID the dates to use...

	A	B	C	D
2	Monday, December 1, 2014			Friday, December 5, 2014
3	Tuesday, December 2, 2014			Friday, December 12, 2014
4	Wednesday, December 3, 2014			Friday, December 19, 2014
5	Thursday, December 4, 2014			Friday, December 26, 2014
6	Friday, December 5, 2014	12/5/2014
7	Saturday, December 6, 2014
8	Sunday, December 7, 2014
9	Monday, December 8, 2014
10	Tuesday, December 9, 2014
11	Wednesday, December 10, 2014
12	Thursday, December 11, 2014
13	Friday, December 12, 2014	12/12/2014
14	Saturday, December 13, 2014
15	Sunday, December 14, 2014
16	Monday, December 15, 2014
17	Tuesday, December 16, 2014
18	Wednesday, December 17, 2014
19	Wednesday, December 17, 2014
20	Friday, December 19, 2014	12/19/2014
21	Saturday, December 20, 2014
22	Monday, December 22, 2014
23	Monday, December 22, 2014
24	Tuesday, December 23, 2014
25	Wednesday, December 24, 2014
26	Thursday, December 25, 2014
27	Friday, December 26, 2014	12/26/2014
28	Saturday, December 27, 2014
29	Sunday, December 28, 2014
30	Monday, December 29, 2014
31	Tuesday, December 30, 2014
32	Wednesday, December 31, 2014

B2=IF(OR(COUNTIF($A$2:A2,A2)>1,WEEKDAY(A2,2)<>5),"",A2)

Then to extract the dates...
D2=IFERROR(INDEX($B$2:$B$32,MATCH(0,INDEX(COUNTIF($D$1:D1,$B$2:$B$32),),0)),"")
This could be put on a different sheet if needed

That worked fine. After thinking more about what what I need to do I will be better off only to find the first day of the week - that being a Monday. How can we rework the following formula to find the first day of the week: =IF(OR(COUNTIF($A$2:A2,A2)>1,WEEKDAY(A2,2)<>5),"",A2)

thanks!

[emortals]

Never mind, i got it with:

=IF(OR(COUNTIF($A$2:A2,A2)<>1,WEEKDAY(A2,2)<>1),"",A2)

thank you for your solution!

[FDibbins]

G;ad it worked for you and thanks for the feedback