How to extract the 3rd Friday of a Month

[Pierre]

An easy question for Excel Gurus....
How can I extract the day (Monday, Tuesday...) of a date ?

Basiquely, I want to extract the last 3rd Friday of each month for th
5 next years..

Tx to all...

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/DateTimeWS.htm

 

[Bob Phillips]

Pierre,

Assuming a date is in A1, the first Friday of that month is

=A1-DAY(A1)+8-WEEKDAY(A1-DAY(A1)+2)

add 14 and you get the third

=A1-DAY(A1)+8-WEEKDAY(A1-DAY(A1)+2)+14

If you just want a straight list, put this in A1

=DATE(2004,ROW(),1)-DAY(DATE(2004,ROW(),1))+8-WEEKDAY(DATE(2004,ROW(),1)-DAY
(DATE(2004,ROW(),1))+2)+14

and copy down

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)