You could also use:
=A1-(DAY(A1)-1)
--
** John C **

"Andrew Mackenzie" wrote:

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.