Dear Jonathan

Could this formula be adapted to allow you to pick the 4th Thursday of any
Month

Thanks you

Stew

"Jonathan Cooper" wrote:

I double checked your formula but did not seem to follow the calender
Thursdays for 2008, so this is what I came up with.

Assuming the 3rd thursday of the first month is entered in B2

=IF(WEEKDAY(DATE(YEAR(B2),MONTH(B2)+1,1),2)=4,DATE (YEAR(B2),MONTH(B2)+1,1)+14,IF(WEEKDAY(DATE(YEAR(B 2),MONTH(B2)+1,1),2)4,DATE(YEAR(B2),MONTH(B2)+1,1 )+21-WEEKDAY(DATE(YEAR(B2),MONTH(B2)+1,1),2)+4,DATE(YEA R(B2),MONTH(B2)+1,1)+14+4-WEEKDAY(DATE(YEAR(B2),MONTH(B2)+1,1),2)))

"FSt1" wrote:

Opps.
forgot to mention.
copy down as far as you need.

Regards
FSt1

"FSt1" wrote:

hi
if you entered this coming 3rd thrusday(12/18/08) in a2, in A3, enter......
=DATE(YEAR(A2),MONTH(A2)+1,DAY(A2))

regards
FSt1


"Malinda" wrote:

I'm putting together a amoritization table and my payments are the 3rd
Thursday of the month for the next 5 years. I do not want to manually enter
these. What formula would i use?