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

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?

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

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?

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

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?

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

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)....

"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?

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

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?

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

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

"Malinda" wrote:

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)....

"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?

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

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))))



--

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

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?