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)
Syntax
=Ex_DividendDate(Symbol)Returns
Ex-dividend date in date format
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
Why is the date in the past?
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.
Why am I getting "NA"?
The company either:
- Does not pay dividends
- Has suspended its dividend
- Symbol may be incorrect
- Try using
ExDividendDate()instead (different data source)
What's the difference between Ex_DividendDate and ExDividendDate?
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.
Do I qualify for the dividend?
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.
Related Formulas
More MarketXLS Dividends formulas you can use in the same worksheet:
- Forward Annual Dividend Yield
- Total Dividends Between Two Dates
- Consecutive Period of Increasing Dividend Payout
- Consecutive Period of Uninterrupted Dividend
- Dividend Frequency
- Dividend Per Share (TTM)
- Dividend Per Share 5 Year CAGR
See Ex_DividendDate 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