Help with an Excel formula?
=MATCH(1,(MONTH(TODAY())=MONTH(1:1))*(YEAR(TODAY() )=YEAR(1:1)),0)
which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Victor Delta" wrote in message
...
I have an Excel spreadsheet with column headings (in Row 1) - some of which
are dates (past, present and future, one for each month) and others are
text.
Can anyone please help me with a formula that will give the column number
for the column with the heading that contains a date with the same month
as
today(). It would be simpler if there weren't the text headings as well to
contend with!
Many thanks,
V
|