Pay Date (On Demand)
Returns the dividend payment date (the date when dividend payments are distributed to shareholders) using QuoteMedia's on-demand data service.
Key Dividend Dates
| Date | Description |
|---|---|
| Declaration Date | When dividend is announced |
| Ex-Dividend Date | First day stock trades without dividend |
| Record Date | Date to be on record to receive dividend |
| Pay Date | Date dividend is paid to shareholders |
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, VYM |
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| Symbol | String | Yes | Stock ticker symbol |
Notes
- Returns the next or most recent pay date
- Not all stocks pay dividends
- Date format may vary
Examples
=QM_PayDate("AAPL")=QM_PayDate("MSFT")=QM_PayDate("JNJ")=QM_PayDate(A1)When to Use
- Track dividend payment schedule
- Income investing planning
- Cash flow timing analysis
- Dividend calendar management
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need ex-dividend date | ExDividendDate() |
| Need dividend amount | DividendAmount() |
| Need dividend yield | DividendYield() |
| Need dividend history | Historical dividend functions |
Common Issues & FAQ
Q: Why am I getting N/A or blank? A: The stock may not pay dividends. Many growth stocks reinvest profits rather than paying dividends.
Q: Is this the next pay date or the last pay date? A: This typically returns the most recent or upcoming pay date depending on where we are in the dividend cycle.
Q: What timezone/format is the date in? A: Dates are typically in US format. You may need to use Excel's DATEVALUE() to convert for date calculations.
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?