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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to implement two shifts per day with multiple teams 0
Extract Number of Weekdays (Mon-Fri) & Saturdays for a particular Month/Yr 13
Search closest day in the past from today 2
Getting a Result in vlookup dependent on another formula 1
if statements returning dates 4
need qualifier statement 5
Calculate Payment Days and Date 7
find out specific month and year 1

Top