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.