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.