Thread: Finding Particular Day of Month
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Finding Particular Day of Month
On 18 Apr 2007 08:54:16 -0700, DF wrote:

Is there a way to find the second Wednesday of each month using Excel
97?

With some date in the month of concern in A1, try:

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


--ron
Reply With QuoteReply With Quote