Gets the First day in a Quarter
Returns an Excel date representing the first day of the specified quarter. Q1 starts Jan 1, Q2 starts Apr 1, Q3 starts Jul 1, Q4 starts Oct 1.
Parameters
| Parameter | Description | Range |
|---|---|---|
| QuarterValue | Quarter number | 1-4 |
| YearValue | Four-digit year | 2000+ |
Quarter Start Dates
| Quarter | Start Date |
|---|---|
| Q1 | January 1 |
| Q2 | April 1 |
| Q3 | July 1 |
| Q4 | October 1 |
Examples
=FirstDayInQuarter(1, 2024)=FirstDayInQuarter(2, 2024)=FirstDayInQuarter(4, 2024)=FirstDayInQuarter(A1, B1)When to Use
- Setting quarterly date ranges
- Building quarterly reports
- Creating date-based filters
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need quarter end | LastDayInQuarter() |
| 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?