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
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
Q: What's the difference between DividendDate, Ex_DividendDate, and DividendPayDate? A:
DividendDate()- When dividend is announced/declaredEx_DividendDate()- Cutoff date to receive dividendDividendPayDate()- When dividend is actually paid
Q: Why am I getting "NA"? A: The company either doesn't pay dividends or hasn't announced the next dividend yet.
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?