Return the last day of the current month
You can return the last day in the month by using the EOMONTH function.
Cell "A1" displays a date.
Cell "A2" displays the last day in this month.
Cell "A3" displays an alternative formula.
All these cells have been formatted with the custom number format "dd dddd mmmm yyyy".
DATE - The date as a date serial number given a year, month, day.
EOMONTH - The serial number of the last day of a month before or after a date.
MONTH - The month as an integer given a date serial number.
TODAY - The serial number representing today's date.
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top