Display all Thursday dates in month

Well, you can always find the First Thursday of that month then add 7 days for each occurrance

=CHOOSE(WEEKDAY(G1,14),G1,G1+6,G1+5,G1+4,G1+3,G1+2,G1+1)

Since your are using Excel 2010, try this (with your posted scenario)
This regular formula, copied down, begins the list of consecutive Thursdays, beginning with the first Thursday in the referenced month:

Please Login or Register  to view this content.

EDITED TO INCLUDE THIS:
You could enter the above formula in cell B1 and
put this formula in B2 and down as far as you need

Please Login or Register  to view this content.

Is that something you can work with?

Likely an easier way to go about this but I would put this in B2

Please Login or Register  to view this content.

Then B2 and below would just be the cell above +7

Here's another one...

Data Range

	A	B
1	2015	1/1/2015
2	1	1/8/2015
3		1/15/2015
4		1/22/2015
5		1/29/2015
6	------	------

This formula entered in B1:

=WORKDAY.INTL(EOMONTH(DATE(A$1,A$2,1),-1),1,"1110111")

This formula entered in B2 and copied down to B5:

=IF(MONTH(B$1+ROWS(B$2:B2)*7)<>MONTH(B$1),"",B1+7)

Format B1:B5 as Date

You're welcome. We appreciate the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.