Dividend Date
Returns the dividend date for a stock, which typically represents when the dividend was declared or announced by the company's board of directors.
Dividend Timeline
| Event | Description | Function |
|---|---|---|
| Declaration Date | Board announces dividend (this function) | DividendDate() |
| Ex-Dividend Date | Stock trades without dividend | Ex_DividendDate() |
| Record Date | Must be shareholder by this date | - |
| Payment Date | Dividend is paid | DividendPayDate() |
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT, JNJ |
| ETFs | SYMBOL | VYM, SCHD |
Notes
- Returns "NA" for non-dividend paying stocks
- Date format may vary
Syntax
=DividendDate(Symbol)Returns
string
Dividend date (declaration date) in date format
Examples
=DividendDate("AAPL")=DividendDate("MSFT")=DividendDate("JNJ")=DividendDate("KO")=DividendDate(A1)When to Use
- Tracking dividend announcements
- Monitoring dividend policy changes
- Building dividend calendars
- Research on dividend timing
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need ex-dividend date | Ex_DividendDate() |
| Need payment date | DividendPayDate() |
| Need dividend yield | DividendYield() |
| Need dividend amount | DividendRate() |
Common Issues & FAQ
What's the difference between DividendDate, Ex_DividendDate, and DividendPayDate?
DividendDate()- When dividend is announced/declaredEx_DividendDate()- Cutoff date to receive dividendDividendPayDate()- When dividend is actually paid
Why am I getting "NA"?
The company either doesn't pay dividends or hasn't announced the next dividend yet.
Related Formulas
More MarketXLS Dividends formulas you can use in the same worksheet:
- Dividend Frequency
- Dividend Per Share (TTM)
- Dividend Per Share 5 Year CAGR
- Forward Annual Dividend Rate
- Forward Annual Dividend Yield
- Total Dividends Between Two Dates
- Consecutive Period of Increasing Dividend Payout
- Consecutive Period of Uninterrupted Dividend
See DividendDate used in a complete workbook: Excel Stock Tracker: Build a Professional Portfolio Dashboard in Your Spreadsheet
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?