2nd Thursday of the month
 

I need a formula which:

if cell A1= the month (say 9 for September) and A2 = the year (say 2006)

it will return the date of the 2nd Thursday of the month.

2nd Thursday of the month
 

Hi Patrick,

Applying Chip Pearson's generic formula

( http://www.cpearson.com/excel/DateTimeWS.htm )

to your scenario, try:

=DATE(A2,A1,1+((2-(5=WEEKDAY(DATE(A2,A1,1))))*7)+(5-WEEKDAY(DATE(A2,A1,1))))


---
Regards,
Norman



"Patrick Simonds" wrote in message
...
I need a formula which:

if cell A1= the month (say 9 for September) and A2 = the year (say 2006)

it will return the date of the 2nd Thursday of the month.