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
|