If the date in A1 = 3rd Friday, your formula returns as the first result
the current month date when it should return the next month date. Also,
enter this test date in A1: 1/31/2007. Copy the formula down at least 9
cells. One of the results is 9/14/2007 which is the 2nd Friday for that
month.. The 3rd dow for a month will never be less than the 15th day of the
month.

Biff

"Teethless mama" wrote in message
...
My previous reply formula I put MONTH($C$1) instead of MONTH($A$1). I
tested
even on MONTH($C$1) still work like a charm. The OP wants every 3rd of
Friday
of very month. Try it yourself and find out

"daddylonglegs" wrote:

Hello Zsolt,

I assume that if your account opening date in A1 is on or after the 3rd
Friday of a month that C2 should return the 3rd Friday of the NEXT month,
that's what my suggested formula does

I don't think Teethless Mama's formula will do that and I also believe
that
it will return 14th of a month in months where the 3rd Friday is on the
21st,
but I'm sure that can be adjusted.......

"Zsolt Szabó" wrote:

The winners are Teeehless (or not) mama and Daddylonglegs.
Runner-up Don Guillett. Thank you very much for the awsome fast and
brilliant answers. You made my weekend.
--
Many thanks for your help in advance. Have a wonderful day!
Zsolt


"Zsolt Szabó" wrote:

Happy Sunday everybody!
I'm an options trader and in my live the 3rd Friday of the month its
important. If I have in cell A1 a date (opening the account), what
formula do
I have to use to see the next 3rd friday date in cell C2 and the next
in C3,
C4 etc. Example A1 = 01/14/2007 than in C2 I like to see 01/19/2007
in C3
02/16/2007. Please help me.
--
Many thanks for your help in advance. Have a wonderful day!
Zsolt