How to find the Last Day of Month in Excel?

In this post, you’ll learn know how to find the Last Day of a month in Excel using EOMonth function.

EOMONTH function in Excel

EOMONTH function is used to find the last day of a given month in Microsoft Excel.

Syntax

=EOMONTH(cell reference, number)

Here the number is the number of months after the given month.

Last Day of the Month in Excel

If you want to find the last day of the current month, just specify the second parameter as 0 to the EOMONTH function as shown below.

=EOMONTH(B1, 0)

Note: The function EOMONTH in Excel returns the serial number of the date. You will need to change the format of the cell to Date to display the lat day of the month correctly.

Leave A Reply

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

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021