Formula to fetch the date of first weekend of a month

  • Thread starter Thread starter FARAZ QURESHI
  • Start date Start date
F

FARAZ QURESHI

In Cell $A$1 I insert a certain date.

What formula (or combinations thereof) in another cell would derive the date
of FIRST Saturday in the month of the date inserted in $A$1?

Thanx again guys!
 
Hi,

Try this

=A1-DAY(A1)+CHOOSE(WEEKDAY(A1-DAY(A1)),6,5,4,3,2,1,7)

Mike
 
=DATE(YEAR(TODAY()),MONTH(A1),1)+MOD(7-WEEKDAY(DATE(YEAR(TODAY()),MONTH(A1),1)),7)
 
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

First day of Next Month 5
count total dates for each month 2
How to shift a weekend date to the last or next workday 2
Use first day of month formula in a drop down list 3
Excel Message box with days of month & date. 1
Automatic date entry 7
formual to determine if date falls on weekend, adjust date to Mond 4
Formula help 1

Back
Top