Formula to return the date of the fourth Thursday in a given month/year
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.
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.
Free Windows Admin Tool Kit Click here and download it now
August 25th, 2015 6:41am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics