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