Get first thursday from a year

[Scrambo]

I need help pulling the first thursday from the year specified in a cell. Cell a2 contains a year that will change and I need cell C1 to always return the first thursday of the year in cell a2 and am new to excel and can't find a solution

 

[fhqwgads]

try

Book1
	A	B	C
1			4/01/2018
2	6/07/2018
Sheet18

Cell Formulas
Range	Formula
C1	=DATE(YEAR(A2),1,1+7*1)-WEEKDAY(DATE(YEAR(A2),1,8-5))

hope that works

based on Rick Rothstein's code
http://www.excelfox.com/forum/showthread.php/398-Nth-Such-And-Such-Day-Of-The-Month

 

[Dave Patton]

Excel 2010
	A	B
1
2	2018	Thu January 04, 2018
4b

Cell Formulas
Range	Formula
B2	=DATE(A2,1,1*7+1)-WEEKDAY(DATE(A2,1,8-5))

you can find the nth xday of a given M and Y with this formula
=DATE(Y,M,(n*7)+1)-WEEKDAY(DATE(Y,M,8-x))
where x is a number representing the day of the week from 1 = Sunday through to 7 = Saturday

 

[Tetra201]

Or a shorter one:

=WORKDAY.INTL(("1-"&A2)-1,1,"1110111")