=A1+6-WEEKDAY(A1)

HTH
Jason
Atlanta, GA

-----Original Message-----
Hello.

How can I code a cell to return the "First Friday in a
given month"?
Please assume that cell A1 contains a date which
represents the first
day in the month (i.e. 1/1/05 or 5/1/13).

Thanks.
Michael

*** Sent via Developersdex http://www.developersdex.com
***
Don't just participate in USENET...get rewarded for it!
.