Thread
:
3rd Friday every month
View Single Post
#
3
Posted to microsoft.public.excel.misc
Zsolt Szabó
external usenet poster
Posts: 29
3rd Friday every month
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
Reply With Quote
Zsolt Szabó
View Public Profile
Find all posts by Zsolt Szabó