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
|