MarketXLS

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

Syntax

=FirstDayInQuarter(QuarterValue, YearValue)
Excel Desktop (Windows)

Parameters

quarterValuenumberRequired

Quarter number (1-4)

yearValuenumberRequired

Year (e.g., 2024)

Returns

date

First day of the specified quarter

Examples

=FirstDayInQuarter(1, 2024)
Returns Jan 1, 2024
=FirstDayInQuarter(2, 2024)
Returns Apr 1, 2024
=FirstDayInQuarter(4, 2024)
Returns Oct 1, 2024
=FirstDayInQuarter(A1, B1)
Quarter and year from cells

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

Which calendar does this use?

Standard calendar quarters (Jan-Mar, Apr-Jun, Jul-Sep, Oct-Dec).

Related Formulas

More MarketXLS Date Functions formulas you can use in the same worksheet:

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Gets the First day in a Quarter and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions