Dividend Pay Date
Returns the dividend payment date for a stock. This is the date when the company actually distributes the dividend payment to eligible shareholders.
Dividend Timeline
| Event | Description |
|---|---|
| Declaration Date | Company announces dividend |
| Ex-Dividend Date | Stock trades without dividend |
| Record Date | Must be shareholder by this date |
| Payment Date | Dividend is paid (this function) |
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, VYM |
Notes
- Returns "NA" if the company does not pay dividends
- Returns "NA" if the payment date has not been announced
Syntax
=DividendPayDate(Symbol)Returns
string
Dividend payment date in date format
Examples
=DividendPayDate("AAPL")=DividendPayDate("MSFT")=DividendPayDate("JNJ")=DividendPayDate("KO")=DividendPayDate(A1)When to Use
- Planning cash flow from dividend investments
- Tracking when dividends will be received
- Building dividend income calendars
- Portfolio income forecasting
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need ex-dividend date | Ex_DividendDate() |
| Need dividend declaration date | DividendDate() |
| Need dividend yield | DividendYield() |
| Need dividend amount | DividendRate() |
Common Issues & FAQ
Why am I getting "NA"?
The company either:
- Does not pay dividends
- Has not announced the next payment date
- Symbol may be incorrect
How far in advance is the payment date known?
Typically announced at the same time as the dividend declaration, usually a few weeks to a month before the ex-dividend date.
Related Formulas
More MarketXLS Dividends formulas you can use in the same worksheet:
- Dividend Per Share (TTM)
- Dividend Per Share 5 Year CAGR
- Forward Annual Dividend Yield
- Total Dividends Between Two Dates
- Consecutive Period of Increasing Dividend Payout
- Consecutive Period of Uninterrupted Dividend
- Dividend Frequency
See DividendPayDate used in a complete workbook: Ex-Dividend Dates: Track Multiple Stocks Quickly in Your Excel Spreadsheet (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?