Remember Me?

#1
December 15th 08, 09:24 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Aug 2008 Posts: 7
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?

#2
December 15th 08, 09:53 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 3,942
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?

#3
December 15th 08, 09:58 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 3,942
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?

#4
December 15th 08, 10:14 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Aug 2008 Posts: 7
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
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?

#5
December 15th 08, 10:41 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Mar 2008 Posts: 28
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?

#6
December 15th 08, 10:55 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 3,942
How do I get a formula to calculate the third Thursday of the

opps.
ignore my post.
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
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?

#7
December 16th 08, 12:01 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Dec 2008 Posts: 37
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))))

--

#8
December 16th 08, 03:34 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Mar 2007 Posts: 293
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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post David Excel Discussion (Misc queries) 13 April 16th 18 09:29 PM Witness Excel Discussion (Misc queries) 0 May 9th 08 12:34 AM joe schmo Excel Worksheet Functions 1 February 6th 08 07:23 PM RamseyR Excel Worksheet Functions 3 October 20th 05 08:28 AM UPRAYUP Excel Worksheet Functions 1 August 22nd 05 10:30 AM

All times are GMT +1. The time now is 08:07 AM.