Fiscal Year End Date

Returns the date when the company's fiscal year ends. Companies choose their fiscal year end, which may differ from the calendar year end (December 31).

Common Fiscal Year Ends

Month Examples
December Most companies
September Microsoft
June Adobe, Nike
January Walmart, retailers

Notes

  • Important for comparing financial data
  • Affects when annual reports are filed
  • Quarters are based on fiscal year, not calendar

Examples

=last_fiscal_year_end("AAPL")
Apple's FY end (September)
=last_fiscal_year_end("MSFT")
Microsoft's FY end (June)
=last_fiscal_year_end("WMT")
Walmart's FY end (January)

When to Use

Understanding company reporting periods, financial calendar planning

When NOT to Use

| Need earnings date | earnings_date() | | Need last split date | last_split_date() |

Common Issues & FAQ

Q: Why am I getting "NA"? A: Check that:

  • The symbol is valid
  • You have proper data access
  • Parameters are in correct format

Q: Is this function Excel-only? A: Some functions may not have API endpoints and only work in Excel.

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 Fiscal Year End Date and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions