View Single Post
  #11   Report Post  
David
 
Posts: n/a
Default 1st and 3rd Thursday formula

Dave Peterson wrote

=DATE(YEAR(TODAY()),MONTH(TODAY()),1+7*3
-WEEKDAY(DATE(YEAR(TODAY()),MONTH(TODAY()),8-5)))


Ok, changed other two formulas to match this syntax, i.e., placement of
parentheses, and it works.

p.s. Sorry about not changing date back to today before sending prior post.

--
David