First Saturday

  • Thread starter Thread starter Steved
  • Start date Start date
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.
 
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
 
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...
 
Back
Top