View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Zsolt Szabó Zsolt Szabó is offline
external usenet poster
 
Posts: 29
Default 3rd Friday every month

I think I dont understand something. A1= 01/114/2007.
C3 =A1-DAY(A1)+8+14-WEEKDAY(A1-DAY(A1)+2 RESULT 01/19/2007
C4 =A1-DAY(A1)+8+14-WEEKDAY(A1-DAY(A1)+2 RESULT 01/20/2007

--
Many thanks for your help in advance. Have a wonderful day!
Zsolt


"Don Guillett" wrote:


You could use in c3 and in the others c3+7 and copy down
--
Don Guillett
SalesAid Software

"Zsolt Szabó" wrote in message
...
This formula its working in C3 but not in C4, C5, C6 etc. In C4 or higher
it
brings the same reults 1/19/2007

--
Many thanks for your help in advance. Have a wonderful day!
Zsolt


"Don Guillett" wrote:

this will find the third friday from any valid date in cell t1
=T1-DAY(T1)+8+14-WEEKDAY(T1-DAY(T1)+2)

--
Don Guillett
SalesAid Software

"Zsolt Szabó" wrote in message
...
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