Using Excel 2013, I need a formula that returns the date of the fourth Thursday in a given month. For example, if the date in
A1 = 11/2/2012
B1 needs a formula that references A1 and returns 11/22/2012
or if
A1 = 11/1/2014
B1 needs a formula that references A1 and returns 11/27/2014.
Formula to return the date of the fourth Thursday in a given month/year
April 6th, 2014 6:25pm
You can use this formula:
=DATE(YEAR(A1),MONTH(A1),CHOOSE(WEEKDAY(DATE(YEAR(A1),MONTH(A1),1)),26,25,24,23,22,28,27))
This formula has been derived from http://chandoo.org/wp/2009/11/25/findout-thanksgiving-date/
Free Windows Admin Tool Kit Click here and download it now
April 6th, 2014 7:16pm
Perfect. Thank you, Hans, and best regards.
April 7th, 2014 12:15am
Thanks Hans, just what I was looking for.
*I know you posted it a while ago but I was just looking for this answer today.
*I know you posted it a while ago but I was just looking for this answer today.
Free Windows Admin Tool Kit Click here and download it now
August 25th, 2015 6:41am