Formula to fetch the date of first weekend of a month
 

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!

Formula to fetch the date of first weekend of a month
 

Look he

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

item First weekday of month

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"FARAZ QURESHI" wrote in message
...
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!

Formula to fetch the date of first weekend of a month
 

Hi,

Try this

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

Mike

"FARAZ QURESHI" wrote:

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!

Formula to fetch the date of first weekend of a month
 

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

"Niek Otten" wrote:

Look he

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

item First weekday of month

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"FARAZ QURESHI" wrote in message
...
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!