Finding this month's cell

V

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
 
G

Gary''s Student

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
 
Top