Ex-Dividend Date
Returns the ex-dividend date for a stock using QuoteMedia data.
How It Works
The formula returns the most recently declared ex-dividend date from our data provider (QuoteMedia):
- Date is in the future — the company has announced its next dividend. This is the upcoming ex-dividend date you can act on.
- Date is in the past — the next dividend hasn't been declared yet. The date shown is the last known ex-dividend date. This is normal — companies typically announce their next dividend only 2–4 weeks before the ex-date. Once they announce, the formula automatically updates to the new date.
- Returns "NA" — the stock doesn't pay dividends or has suspended its dividend.
To receive a dividend, you must purchase the stock before the ex-dividend date. If you buy on or after the ex-dividend date, you will not receive the upcoming dividend.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, VYM |
Notes
- A past date does NOT mean the data is stale — it means the next dividend simply hasn't been announced yet
- Try
Ex_DividendDate()if this returns NA (uses a different data source)
Examples
=ExDividendDate("AAPL")=ExDividendDate("MSFT")=ExDividendDate("JNJ")=ExDividendDate("KO")=ExDividendDate(A1)When to Use
- Planning stock purchases around dividends
- Dividend capture strategies
- Building dividend calendars
- Monitoring dividend eligibility dates
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need payment date | DividendPayDate() |
| Need declaration date | DividendDate() |
| Need dividend yield | DividendYield() |
| This returns NA | Try Ex_DividendDate() |
Common Issues & FAQ
Q: Why is the date in the past? A: This means the company hasn't announced its next dividend yet. The formula shows the last known ex-dividend date. Once the company declares its next dividend (typically 2–4 weeks before the ex-date), the formula will automatically update to the new future date. This is completely normal.
Q: Why am I getting "NA"? A: The company either:
- Does not pay dividends
- Has suspended its dividend
- Symbol may be incorrect
- Try using
Ex_DividendDate()instead (different data source)
Q: What's the difference between ExDividendDate and Ex_DividendDate? A: Both return the ex-dividend date but use different data sources. If one returns "NA", try the other.
Q: Do I qualify for the dividend? A: You must own the stock BEFORE the ex-dividend date. If you buy on the ex-dividend date or later, you won't receive the dividend.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today