# First Day of Month – Formulas in Excel and Google Sheets

Download the example workbook

*This tutorial will teach you how to calculate the first day of the month in Excel and Google Sheets.*

## Calculate First Day of the Month

### EOMONTH Function

There’s no Excel function to calculate the first day of the month, but the EOMONTH function will calculate the last day of a month.

To find the first day of a month we will calculate the last day of the previous month and add one day.

Here let’s find the last day of the previous month:

1 |
=EOMONTH(B3,-1) |

Now let’s add one day to the result:

1 |
=EOMONTH(B3,-1)+1 |

### DAY Function

You can also use the DAY Function to find the first day of the month:

1 |
=B3 - DAY(B3)+1 |

Here the DAY Function returns the day number of a date. By subtracting this from the current date (and adding 1) we arrive at the first day of the month.

### Google Sheets Example

These formulas work exactly the same in Google Sheets as in Excel.