Previous Earnings Report Date
Returns the date when the company last reported its quarterly earnings.
Syntax
=mxls.PreviousEarningsReportDate(Symbol)Parameters
symbolstringRequired
numbernumber
Examples
=PreviousEarningsReportDate("AAPL")When to Use
- Earnings calendar tracking
- Historical earnings analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Next earnings | NextEarningsDate() |
Related Formulas
More MarketXLS Estimates formulas you can use in the same worksheet:
- Price to EPS Estimate Current Year
- Price to EPS Estimate Next Year
- Quarterly Earnings Growth YoY
- Target Price
- 5-Year EPS Growth Rate
- Actual EPS
- Analyst Consensus
- Earnings Estimates Consensus Eps Estimates Trends Current Est Fr1 Month Year
See PreviousEarningsReportDate used in a complete workbook: Earnings Data in Excel: Live EPS, Revenue, and Estimate Tracking for May 2026
Market data in your Excel sheets
1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.
See plans
▶
How does MarketXLS work?