Skip to content

Get the First and Last Day of the Current Month

In this article, I show you how to calculate the first and last days of the current month. This method works for both Microsoft Excel and Google Sheets.

Get the Last Day

To get the last day of the current month, use the following formula.

=EOMONTH(TODAY(), 0)

The TODAY function returns the current date, and that date passes to the EOMONTH function.

=EOMONTH(28-Jul-2023, 0)

The EOMONTH function calculates the last day of the month for the provided date. The zero (2nd argument) forces the EOMONTH function to consider the same month as the provided date (1st argument).

= 31-Jul-2023

Get the First Day

To get the first day of the current month, use the following formula.

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

The TODAY function returns the current date, and that date passes to the EOMONTH function.

=EOMONTH(28-Jul-2023, -1) + 1

The EOMONTH function calculates the last day of the month in the month before the provided date. The negative one (2nd argument) forces the EOMONTH function to consider the month before the provided date (1st argument).

= 30-Jun-2023 + 1

Finally, one is added to the date calculated by the EOMONTH function, which gives you the first day of the current month.

= 1-Jul-2023

And that is how to calculate the first and last day of the current month in either Google Sheets or Microsoft Excel.

This Post Has One Comment

  1. I use the EOMONTH function all the time at work! It helps when you run monthly reports for the end of the month. Thanks for sharing the knowledge!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top