MarketXLS

Number Of Employees (Historical)

Returns the historical number of employees for a company. This data is typically reported in annual reports and can show workforce growth or contraction over time.

Supported Symbols

Type Format Example
US Stocks SYMBOL AAPL, MSFT
ETFs SYMBOL SPY, QQQ
International SYMBOL SHOP, TSM

Parameters

Parameter Description
Symbol Stock ticker symbol
Year Fiscal year (2020, 2021) or period code (lq, ly, lt)
Quarter Optional: 1, 2, 3, or 4 for quarterly data
TTM Optional: Set to "TTM" for trailing twelve months

Employee-Based Metrics

Metric Calculation
Revenue per Employee Revenue / Employees
Profit per Employee Net Income / Employees
Assets per Employee Total Assets / Employees

Notes

  • Employee count includes full-time and often part-time workers
  • Contractors may not be included
  • Useful for productivity and efficiency analysis

Syntax

=hf_Number_of_employees(Symbol, Year, [Quarter], [TTM])
Excel Desktop (Windows)

Parameters

symbolstringRequired

Stock ticker symbol

yearstringRequired

Fiscal year or period code (lq, ly, etc.)

quarterstring

Calendar quarter (1-4)

TTMstring

Set to 'TTM' for trailing twelve months

Returns

number

Number of employees

Examples

=hf_Number_of_employees("AAPL", 2023)
Apple employees
=hf_Number_of_employees("AMZN", 2023, 2)
Amazon Q2 2023
=hf_Number_of_employees("GOOGL", "ly")
Alphabet last fiscal year
=hf_Number_of_employees("META", 2023, , "TTM")
Meta TTM
=hf_Number_of_employees(A1, B1, C1)
Cell references

When to Use

  • Analyzing workforce growth trends
  • Calculating revenue per employee
  • Understanding company scaling
  • Comparing efficiency across companies
  • Tracking layoffs and hiring sprees

When NOT to Use

Scenario Use Instead
Need current count Number_of_Employees()
Need labor costs hf_Selling_General_and_Administrative_Expense()
Need compensation data Manual research
Need contractor count Not available

Common Issues & FAQ

Why did Meta's employee count drop sharply?

Meta conducted significant layoffs in 2022-2023, reducing headcount substantially. This is visible in historical data.

Why is Amazon's count so high?

Amazon has a large warehouse and logistics workforce, making it one of the largest employers globally.

Why am I getting "NA"?

Employee data is typically only available annually. Quarterly data may not be available for all companies.

Related Formulas

More MarketXLS Historical Fundamentals 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 Number Of Employees (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions