Thread: How to calculate the third friday of a month?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default How to calculate the third friday of a month?
=DATE(YEAR(A1),MONTH(A1),1+7*3)-WEEKDAY(DATE(YEAR(A1),MONTH(A1),8-6))

with any date in A1 will return the third Friday of the month

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"KJP" wrote in message
...
Does anyone have an idea of how to accomplish this?

Reply With QuoteReply With Quote