Gets the Last day in a Quarter
Returns an Excel date representing the last day of the specified quarter. Q1 ends Mar 31, Q2 ends Jun 30, Q3 ends Sep 30, Q4 ends Dec 31.
Parameters
| Parameter | Description | Range |
|---|---|---|
| QuarterValue | Quarter number | 1-4 |
| YearValue | Four-digit year | 2000+ |
Quarter End Dates
| Quarter | End Date |
|---|---|
| Q1 | March 31 |
| Q2 | June 30 |
| Q3 | September 30 |
| Q4 | December 31 |
Examples
=LastDayInQuarter(1, 2024)=LastDayInQuarter(2, 2024)=LastDayInQuarter(4, 2024)=LastDayInQuarter(A1, B1)When to Use
- Setting quarterly date ranges
- Building quarterly reports
- Calculating quarter-end values
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need quarter start | FirstDayInQuarter() |
| Need month start | FirstDayInMonth() |
Common Issues & FAQ
Q: Which calendar does this use? A: Standard calendar quarters (Jan-Mar, Apr-Jun, Jul-Sep, Oct-Dec).
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?