Get first thursday from a year

Scrambo

New Member
Joined
Nov 19, 2018
Messages
4
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
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Excel 2010
AB
1
22018Thu January 04, 2018
4b
Cell Formulas
RangeFormula
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
 
Upvote 0

Forum statistics

Threads
1,225,286
Messages
6,184,059
Members
453,208
Latest member
Palo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top