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
Syntax
=QM_PayDate(Symbol)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
Why am I getting N/A or blank?
The stock may not pay dividends. Many growth stocks reinvest profits rather than paying dividends.
Is this the next pay date or the last pay date?
This typically returns the most recent or upcoming pay date depending on where we are in the dividend cycle.
What timezone/format is the date in?
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?