View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Second Saturday Of The Month

On Wed, 26 Mar 2008 13:25:01 -0700, FrankM
wrote:

OK, this may seem fairly simple but I'm missing something ...

Is there a formula that will calculate the Second Calendar Saturday of the
Month for me?


I should have written:

With some date in the desired month in A1:

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

Or, for "this" month, substitute TODAY() for A1 in the above formula.
--ron