Hi,

It really depends on how your months are entered in the headings, for
example if they are Jan, Feb,... then the following formula will return 9 for
september, the current month:

=MATCH(TEXT(NOW(),"mmm"),A1:L1)

where A1:L1 are your month titles.

--
Thanks,
Shane Devenshire


"Victor Delta" wrote:

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