Thread: How do I get a formula to calculate the third Thursday of the mont
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
  
Posts: 3,942
Default 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?
Reply With QuoteReply With Quote