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

Stand with Ukraine

As the situation in Ukraine escalates, many of us in MarketXLS are left with emotions too overwhelming to name. If you’d like to show your support, but aren’t sure how to, we want to help make it easier for you to act.

For any amount donated, we’ll extend your MarketXLS subscription for double of the donated amount. Please send proof of your payment to support@marketxls.com to avail the extention

From all of us at MarketXLS, thank you!