Formula to fetch the date of first weekend of a month

[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!

 

[Niek Otten]

Look here:

http://www.cpearson.com/excel/DateTimeWS.htm#NthDoWYear

item First weekday of month

 

[Mike H]

Hi,

Try this

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

Mike

 

[joel]

=DATE(YEAR(TODAY()),MONTH(A1),1)+MOD(7-WEEKDAY(DATE(YEAR(TODAY()),MONTH(A1),1)),7)