Help with a formula please?

  • Thread starter Thread starter Victor Delta
  • Start date Start date
V

Victor Delta

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
 
Victor Delta said:
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!
Click to expand...

Sorry - please ignore - meant to post this as a new thread, and have now
done so.

Senior moment...
 
Back
Top