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...
 
You must log in or register to reply here.

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

Re: How can I count the number of SATURDAYS in a month? 0
Formatting Dates 1
Extract Number of Weekdays (Mon-Fri) & Saturdays for a particular Month/Yr 13
Getting a Result in vlookup dependent on another formula 1
first saturday in a month 8
Testing a cell value for a specific weekday. 3
if statements returning dates 4
need qualifier statement 10

Back
Top