To get the beginning of this month:

=EOMONTH(TODAY(),-1)+1

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Andrew Mackenzie" wrote in message
...
Can anyone tell me whether there is a function similar to =EOMONTH to
refer
to the beginning of the month instead of the end of the month that the
function is referencing?

Failing that is there some formula I could use?

Many thanks in advance.

Andrew.