MarketXLS

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

Syntax

=DividendBetweenTwoDates(Symbol, StartDate, EndDate)
Excel Desktop (Windows)

Parameters

symbolstringRequired

Stock ticker symbol

startDatedateRequired

Start date for dividend calculation

endDatedateRequired

End date for dividend calculation

Returns

number

Total dividends paid per share between the two dates

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

Why am I getting "NA"?

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

Does this include special dividends?

Yes, all dividend payments with ex-dates within the range are included.

How do I calculate total income from dividends?

Multiply the result by the number of shares held: =DividendBetweenTwoDates("AAPL", DATE(2023,1,1), DATE(2023,12,31)) * 100 for 100 shares

Excel Templates Using Total Dividends Between Two Dates

These ready-made MarketXLS templates call DividendBetweenTwoDates() in their worksheet formulas. Open one to see the function working inside a complete model.

Related Formulas

More MarketXLS Dividends formulas you can use in the same worksheet:

See DividendBetweenTwoDates used in a complete workbook: VTSAX: Complete Guide to Vanguard's Total Stock Market Fund (2026)

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