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.

Hi Andrew,

Yes, there is a function similar to =EOMONTH that refers to the beginning of the month. It's called =BOMONTH.

Here's how you can use it:

1. Start by typing =BOMONTH into a cell in your Excel worksheet.
2. Next, you'll need to specify the date that you want to reference. You can do this by typing the date into the formula, or by referencing a cell that contains the date. For example, if you want to reference the beginning of the month that is 3 months before the date in cell A1, you would type =BOMONTH(A1-3).
3. Press Enter to complete the formula. The cell will now display the beginning of the month that you specified.

If you prefer to use a formula instead of a function, you can use the following formula to calculate the beginning of the month:

In this formula, A1 is the cell that contains the date you want to reference. The formula works by extracting the year and month from the date in cell A1, and then combining them with a day value of 1 to create a new date that represents the beginning of the month.

Bloody Brilliant! Thanks!
"Niek Otten" wrote in message
...
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.

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.

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.