How do I get a formula to calculate the third Thursday of the mont

[Malinda]

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?

 

[FSt1]

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

 

[FSt1]

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

Regards
FSt1

 

[Malinda]

This answer kept my date as the 20th.... I.E. in B18 i had 11/20/2008, and
in c19 with the formula below (=date(year(b18),month(b18)+1,day(b18)). The
answer was 12/20/2008.
When i copied down, it gave me the 20th of every month following. however i
want the thursday (i.e. third Thurdsday).. (or specifically 12/18/2008 and
so on)....

 

[Jonathan Cooper]

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(B2),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(YEAR(B2),MONTH(B2)+1,1)+14+4-WEEKDAY(DATE(YEAR(B2),MONTH(B2)+1,1),2)))

 

[FSt1]

opps.
i misread you post.
ignore my post.
sorry to waste your time.
regards
FSt1

 

[Chris Premo]

The following can be used to calculate the X day of the Y weeks

A B
1 5/16/2009
2 Day of Week 6
3 No of Weeks 2
4 Calculator 5/8/2009


This formula is placed in cell B4:

=IF(B2-WEEKDAY(DATE(YEAR(B1),MONTH(B1),1))<0,DATE(YEAR(B1),MONTH(B1),1)+
B3*7+(B2-WEEKDAY(DATE(YEAR(B1),MONTH(B1),1))),DATE(YEAR(B1),MONTH(B1),1)
+(B3-1)*7+(B2-WEEKDAY(DATE(YEAR(B1),MONTH(B1),1))))



--

 

[stew]

Dear Jonathan

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

Thanks you

Stew