compare date ranges to set up eq

C

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 k
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

compare date to column data 1
How to getting text labels to show up in scatter chart. 0
How do I combine 2 data sets using date? 2
Count Dates in a range based on Column Header Id without using sum-product 1
YTD SUMIF based on current date 3
When building a chart Dates are been included that are not in thedate range 2
IF function question 1
Date 2

Top