=BOMONTH?

[Andrew Mackenzie]

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.

 

[Andrew Mackenzie]

Bloody Brilliant! Thanks!

To get the beginning of this month:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

 

[Niek Otten]

To get the beginning of this month:

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

 

[John C]

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