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

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
--
Gary's Student
gsnu200703


"Victor Delta" wrote:

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

Where a3 contains the date
=MATCH(A3,B1:L1,0)
--
Don Guillett
SalesAid Software

"Victor Delta" wrote in message
...
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

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

--
Don Guillett
SalesAid Software

"Victor Delta" wrote in message
...
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

"Don Guillett" wrote in message
...
or this array entered to look for April
=MATCH(4,MONTH(B1:J1))

Many thanks. Just the job!

V

Glad to help

--
Don Guillett
SalesAid Software

"Victor Delta" wrote in message
...
"Don Guillett" wrote in message
...
or this array entered to look for April
=MATCH(4,MONTH(B1:J1))

Many thanks. Just the job!

V