MarketXLS

Gets the First day in a Month

Returns an Excel date representing the first day of the specified month and year. Useful for date range calculations.

Parameters

Parameter Description Range
MonthValue Month number 1-12
YearValue Four-digit year 2000+

Syntax

=FirstDayInMonth(MonthValue, YearValue)
Excel Desktop (Windows)

Parameters

monthValuenumberRequired

Month number (1-12)

yearValuenumberRequired

Year (e.g., 2024)

Returns

date

First day of the specified month

Examples

=FirstDayInMonth(1, 2024)
Returns Jan 1, 2024
=FirstDayInMonth(6, 2024)
Returns Jun 1, 2024
=FirstDayInMonth(A1, B1)
Month and year from cells

When to Use

  • Setting date ranges for analysis
  • Building monthly reports
  • Creating date-based filters

When NOT to Use

Scenario Use Instead
Need quarter start FirstDayInQuarter()
Need quarter end LastDayInQuarter()

Common Issues & FAQ

What format is the output?

Returns an Excel date serial number that displays as a date.

Excel Templates Using Gets the First day in a Month

These ready-made MarketXLS templates call FirstDayInMonth() in their worksheet formulas. Open one to see the function working inside a complete model.

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 Month and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions