Return the last day of the previous quarter


 A
1=TODAY() = 19/05/2024
2=NOW() = 5/19/2024 13:52
3=DATE(YEAR(TODAY()), MONTH(TODAY())+1, 0) = 31/05/2024

Built-in Functions

DATE - The date as a date serial number given a year, month, day.
NOW - The date serial number of the current system date and time.
YEAR - The year as an integer given a date serial number.
TODAY - The date 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 quarter
Return the first day of the previous quarter
Return the last day of the current quarter


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