Ex-Dividend Date
Returns the ex-dividend date for a stock.
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
- This function also works in Excel Online
- Try
ExDividendDate()if this returns NA (uses a different data source)
Examples
=Ex_DividendDate("AAPL")=Ex_DividendDate("MSFT")=Ex_DividendDate("JNJ")=Ex_DividendDate("VYM")=Ex_DividendDate(A1)When to Use
- Tracking dividend investment opportunities
- Planning stock purchases around dividend dates
- Building dividend capture strategies
- Monitoring portfolio dividend schedules
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need dividend payment date | DividendPayDate() |
| Need dividend declaration date | DividendDate() |
| Need dividend yield | DividendYield() |
| Need dividend amount | DividendRate() |
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
ExDividendDate()instead (different data source)
Q: What's the difference between Ex_DividendDate and ExDividendDate?
A: Both return the ex-dividend date but use different data sources. If one returns "NA", try the other. Ex_DividendDate also works in Excel Online.
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