Thread: How do I get a formula to calculate the third Thursday of the mont
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Chris Premo Chris Premo is offline
external usenet poster
  
Posts: 37
Default 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))))



--

Reply With QuoteReply With Quote