Return the last day of the previous month


 A
1=TODAY() = 09/07/2020
2=NOW() = 7/9/2020 12:28
3=DATE(YEAR(TODAY()),MONTH(TODAY())+1,0) = 31/07/2020

Built-in Functions

DATE - The date as a date serial number given a year, month, day.
NOW - The serial number of the current system date and time.
YEAR - The year as an integer given a date serial number.
TODAY - The serial number representing today's date.
MONTH - The month as an integer given a date serial number.


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 current month
Return the last day of the previous month


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