First Saturday

S

Steved

Hello from Steve Dee

I am doing a spread sheet that requires a formula for 1st
Saturday of the month. In A1 input the first of the month.
In B1 what would the formula be for it give the date of
the first Saturday. As I change the date each month in A1
this will give me the first Saturday in B1.

Thankyou.
 
C

Chip Pearson

Steved,

If A1 is the first of the month, then the following formula will
return the first Saturday of the month:

=A1+CHOOSE(WEEKDAY(A1),6,5,4,3,2,1,0)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
V

Vasant Nanavati

Or:

=A1+7-WEEKDAY(A1)

--

Vasant


Chip Pearson said:
Steved,

If A1 is the first of the month, then the following formula will
return the first Saturday of the month:

=A1+CHOOSE(WEEKDAY(A1),6,5,4,3,2,1,0)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
Click to expand...
 
Top