Determine which column to use by date

M

Mike Griffin

I have a range of 14 rows by 12 columns. Each column represents a
different month. How can I determine which column to use, if I only
want to use the column for the current month?
 
G

Gary''s Student

lets say cols A-L are Jan thru Dec

=MONTH(TODAY()) formatted as an integer will tell you which column to use
for the current date.
 
P

Pete_UK

The function TODAY() will give today's date. With the MONTH( ) function
wrapped around this, you will get the month (eg 3 for March), so you
will need to add something to this to suit your range. Say for example
your range starts in column F for January (i.e. the 6th column), then
this formula:

=MONTH(TODAY())+5

would give the column number. If you want this as a letter, then this
amendment:

=CHAR(64+MONTH(TODAY())+5)

would suffice.

Hope this helps.

Pete
 
M

Mike Griffin

Yes, that gets me the column!

Now, my question is how to use that column letter or number in another
formula concatenated with the row number.

eg. =IF($(CHAR(64+MONTH(TODAY())+5)$3='NO', blah, blah))

I hope that makes sense
 
Top