compare date to column data

[Custermd]

I need help.

on one worksheet i have a row with the months of the year . I am tryin
to compare the current date with these columns to see which column th
current date would relate to.

------a---b---c----d----e----f----g---h----i----j
01) jul--aug-sep--oct-nov--dec-jan--feb-mar-apr

If the current date is 21feb06 the the column would relate to colum
(i)

thus the equations on another ws would relate to data in column i


If the current date is 15apr06 the the column would relate to colum
(k)

thus the equations on another ws would relate to data in column (k)

Thankyo

 

[vezerid]

The following formula assumes that your months are in A1:K1. From what
I see you want to match a Feb date to March. Assuming your date is in
cell A4, then the following formula will give you the relative position
of the appropriate month in A1:K1:

=MATCH(DATE(YEAR(A4),MONTH(A4)+1,1),DATEVALUE("1 "&A1:K1&"
"&YEAR(A4)-2000),0)

This is an *array* formula, it must be entered with Shift+Ctrl+Enter.

For a value of 21feb06 in A4 this formula will give you the number 9,
which is the relative column number of mar in your range.

I don;t know what else you want to do but this might be a start.

HTH
Kostis Vezerides