Counting days and array element reference

[330006]

Hi all, I am new to excel, so pardon my ignorance. I did a search, but
still can't figure this out:

1. Suppose I have many rows of dates: "MAY99", "JUN99", etc. Each row
always referes to the third Friday of the month. I want to add a column
to the file: the number of days from the starting day. So if we set the
starting date to be 05/01/99, for the row of "MAY99", let's say the
third Friday of MAY of 1999 is May 20th. Then for this new column, the
entry for the new column is 20. (Ideally, I want to count in business
days, rather than calendar days)

How can I do that?

2. In other language, to acess certain row of an array is easy: A, I
can do a loop on i. For example:
i = 1,4,7,10,etc.

But how can I do this in excel/VBA? Let's say I want to refer to cell
A1, A4, A7, A10, etc? (as in VBA: i write "A8" not "A[8]" where "8" can
cange, so i find it hard.

Thanks a lot, appreciate your help!

 

[Mika Oukka]

Q1
to test fill range C4:B14 with test values 1999 and range B4:B15 should
include values from 1 to 12.
Formula for 1:st days weekday of month:
D4: =WEEKDAY(DATE(C4,B4,1))
Result 1=Sunday, 2=Monday,...

To find the 3:rd friday based on the 1st day calculation above
E5: =IF(D4<=6,(6-D4)+(2*7+1),(6-D4)+(3*7+1))

Workday might be the function youre looking also. Excels helps are specially
good for functions.

Q2
Here is one example how to use array and how to refer to cells.
Rws = Array("5", "9", "1")
For i = 0 To 2
Cells(Rws(i), 8).Select
Selection.Font.Bold = True
Next

You can also type "cells" to VBA code, select the word and press F1 for more
instructions.

-Mika