Use the EOMONTH function to determine the last day of a month - Date and Time Functions - Microsoft Excel Tutorials

Use the EOMONTH function to determine the last day of a month using Microsoft Excel

To find the last day of a month, use the EOMONTH function (EOMONTH(start_date, offset_months)). This function returns the date of the last day of the month, offset_months from start_date. If the function is not available, load the Analysis ToolPak add-in. Select Add-Ins... from the Tools menu bar and select Analysis ToolPak.

To determine the last day of a month:

1. In cells A2:A10 enter some dates.
2. In cells B2:B10 enter the desired offset from the start date (positive or negative values).
3. Select cells C2:C10 and type the following formula:
=EOMONTH(A2,B2).
4. Press <-Ctrl+Enter->.

Use the EOMONTH function to determine the last day of a month

Watch the Video Tutorial - https://www.youtube.com/watch?v=2y9snQMbJPU