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".

 A
1=TODAY() = 02 Monday December 2019
2=EOMONTH(TODAY(),0) = 31 Tuesday December 2019
3=DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)-1 = 31 Tuesday December 2019

Built-in Functions

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.


Related Formulas

Return the first day of the current month
Return the first day of the next month
Return the first day of the previous month
Return the last day of the next month
Return the last day of the previous month


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top