Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Logout MarketXLS

Ex Dividend Date

The ex-dividend date is the day the stock began to trade without the right to its latest dividend payment. This means that an investor who bought the stock on its ex-dividend date or later was not eligible to receive the declared dividend.

How calculated

No Calculations

Example usage

=Ex_DividendDate("MSFT") - Returns the ex-dividend date for MSFT.


On this date, the stock has to be in your demat account for you to receive the dividend.


Stocks ETFs