"Bob Phillips" wrote in message
...
=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.

Bob

Many thanks - works a treat!

Regards,

V