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+ |
Examples
=FirstDayInMonth(1, 2024)=FirstDayInMonth(6, 2024)=FirstDayInMonth(A1, B1)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
Q: What format is the output? A: Returns an Excel date serial number that displays as a date.
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?