Thread: Find date of 3rd Wed of month
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Find date of 3rd Wed of month
On Sun, 08 Mar 2009 00:11:47 -0500, Chuck wrote:

How can I find the date (number) of the third wednesday of a month?

Chuck

With any date in A1,

=A1-DAY(A1)+22-WEEKDAY(A1-DAY(A1)+4)

will return the third Wednesday of that month.
--ron
Reply With QuoteReply With Quote