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