Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
1st and 3rd Thursday formula | Excel Discussion (Misc queries) | |||
I need a formula that returns weekends and holidays for each mont | Excel Discussion (Misc queries) | |||
formula for if result is friday, make it thursday. | Excel Worksheet Functions | |||
Need formula to have date in cell B2 rounded to first of next mont | Excel Worksheet Functions | |||
Age with mont in decimal | Excel Worksheet Functions |