How to calculate the last day of the month in Excel

To get the date of the last day of the month in Excel, use the function EOMONTH (End of Month). In the version – EOMONTH (the end of the month).

1. For example, let’s try to get the date of the last day of the current month.

   =EOMONTH(A1,0)

   =КОНМЕСЯЦА(A1;0)

Note: function EOMONTH (EOMONTH) returns the serial number of the date. Apply the date format for correct display.

2. Now let’s try to calculate the date of the last day of the next month.

   =EOMONTH(A1,1)

   =КОНМЕСЯЦА(A1;1)

   

3. We can even calculate the date of the last day of a month that was 8 months ago using the formula below:

   =EOMONTH(A1,-8)

   =КОНМЕСЯЦА(A1;-8)

   

Note: The calculations go something like this: = 6 – 8 = -2 or -2 + 12 = 10, i.e. turns out October 2011.