Return the last day of the previous quarter

	A
1	=TODAY() = 01/05/2024
2	=NOW() = 5/1/2024 6:13
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