To get the last day of the month in Exceluse the EOMONTH function.
Join the channel Telegram of the AnonyViet 👉 Link 👈 |
Get the last day of the month in Excel
1. For example, get the last day of the current month.
Note: the EOMONTH function returns the ordinal number of the date. Apply the Date format to display the date.
2. For example, take the last day of the next month.
3. For example, take the last day of 8 months ago.
In addition, you can also view many other excel articles here.