Dividend Frequency
Returns how often a company pays dividends (e.g., Quarterly, Monthly, Semi-Annual, Annual).
Syntax
=DividendFrequency(Symbol)Examples
=DividendFrequency("AAPL")=DividendFrequency("O")When to Use
- Income portfolio planning
- Cash flow timing analysis
- Dividend strategy selection
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Dividend amount | DividendPerShare() |
| Next payment date | DividendPayDate() |
Common Issues & FAQ
What frequencies are possible?
Monthly, Quarterly, Semi-Annual, Annual, or Irregular.
Related Formulas
More MarketXLS Dividends formulas you can use in the same worksheet:
- Dividend Payout Ratio
- Dividend Per Share 5 Year CAGR
- Dividend Rate (Forward)
- Ex-Dividend Date
- Ex-Dividend Date
- Forward Annual Dividend Rate
- Forward Annual Dividend Yield
- Total Dividends Between Two Dates
See DividendFrequency used in a complete workbook: Monthly Dividend Yield: Calculate and Track Your Income Using Excel in 2026
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?