Correction.

For my method, another column is needed:

In E18: =D18+7*(MONTH(D18)<MONTH(A18))

"Martin P" wrote:

Start with the first day of the month in column A. Let's say you have
=date(2005,4,1) in cell A18. In cell B18 enter =weekday(A18). In cell C18
enter =6-B18.
In cell D18 enter =A18+B18, which gives you the first Friday of April 2005.

The procedure for the last Tuesday of every month is similar, but take the
last day of the month, and subtract from 3 instead of 6.

"Dale" wrote:

Hi, fairly new to spreadsheets but I keep trying. Any idea how to insert
the first Friday of a month into columns? I know the (today) and (date)
functions but what if I wanted a specific day of the month. Like the first
Friday or even the last Tuesday? Thanks
Dale