Finding this month's cell

[Victor Delta]

I have a spreadsheet with successive months in the cells of row A (actually
the dates correspond to the first of each month).

I need an expression which will tell me the cell reference (or just the
column reference) corresponding to this month. I know it can't be difficult
but so far my attempts have failed.

Can anyone help please?

Thanks,

V

 

[Guest]

if A1 thru L1 contain:

1/1/2007
2/1/2007
3/1/2007
4/1/2007
5/1/2007
6/1/2007
7/1/2007
8/1/2007
9/1/2007
10/1/2007
11/1/2007
12/1/2007

then
=MONTH(TODAY())
will return the correct column number. two for today

 

[Don Guillett]

Where a3 contains the date
=MATCH(A3,B1:L1,0)

 

[Don Guillett]

or this array entered to look for April
=MATCH(4,MONTH(B1:J1))

 

[Victor Delta]

or this array entered to look for April
=MATCH(4,MONTH(B1:J1))

Many thanks. Just the job!

V

 

[Don Guillett]

Glad to help