Total Dividends Between Two Dates

Calculates the total dividends paid per share for a stock between two specified dates. This is useful for calculating total income from dividend-paying stocks over a specific period.

Parameters

Parameter Required Description
Symbol Yes Stock ticker symbol
StartDate Yes Beginning of date range
EndDate Yes End of date range

Date Formats

Dates can be entered as:

  • Excel DATE function: DATE(2023,1,1)
  • Date string: "2023-01-01"
  • Cell reference containing a date

Notes

  • Returns total dividends per share, not total dollar amount
  • Includes all dividend payments with ex-dates in the range
  • Multiply by shares held to get total dividend income

Examples

=DividendBetweenTwoDates("AAPL", DATE(2023,1,1), DATE(2023,12,31))
2023 total dividends
=DividendBetweenTwoDates("MSFT", DATE(2022,1,1), DATE(2023,12,31))
2-year dividends
=DividendBetweenTwoDates("JNJ", "2023-01-01", "2023-12-31")
String date format
=DividendBetweenTwoDates(A1, B1, C1)
Cell references
=DividendBetweenTwoDates("KO", DATE(2023,1,1), TODAY())
Year-to-date dividends

When to Use

  • Calculating total dividend income for tax purposes
  • Analyzing dividend growth over custom periods
  • Comparing dividend payments across time frames
  • Portfolio income analysis
  • Dividend reinvestment calculations

When NOT to Use

Scenario Use Instead
Need annual dividend yield DividendYield()
Need next dividend date NextDividendDate()
Need dividend payment history DividendHistory()
Need current annual dividend DividendRate()
Need dividend per share (annual) DividendPerShare()

Common Issues & FAQ

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

  • The symbol is valid and pays dividends
  • The date range is valid (start before end)
  • There were dividend payments in the specified range
  • Date format is correct

Q: Does this include special dividends? A: Yes, all dividend payments with ex-dates within the range are included.

Q: How do I calculate total income from dividends? A: Multiply the result by the number of shares held: =DividendBetweenTwoDates("AAPL", DATE(2023,1,1), DATE(2023,12,31)) * 100 for 100 shares

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 Total Dividends Between Two Dates and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions