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

Shane

Thanks for suggesting this but, even changing the bit in inverted commas to
"mmm yy" to correspond to the month formatting I'm using, still gives an
erroneous output.

Regards,

V