Thread: Find 2nd & 4th saturday for every month
View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.misc
[email protected] aolson@su.edu is offline
external usenet poster
  
Posts: 3
Default Find 2nd & 4th saturday for every month
This seems to work for referencing today's date
=DATE(YEAR(TODAY()),MONTH(TODAY()),1+7*2)-WEEKDAY(DATE(YEAR(TODAY()),MONTH(TODAY()),1))
Reply With QuoteReply With Quote