Adjusted Close (Month End)
Returns the adjusted closing price for a stock or ETF on the last trading day of the specified month. Accounts for stock splits and dividend distributions.
Validation
- Month must be 1-12
- Returns "Invalid Month. Use 1-12." for out-of-range values
- Correctly handles leap years (Feb 28 vs 29)
Syntax
=Adjusted_Close_MonthEnd(Symbol, Year, Month)Parameters
SymbolstringRequired
Stock or ETF ticker symbol
YearintegerRequired
The year (e.g., 2025)
MonthintegerRequired
Month number: 1 (January) through 12 (December)
Returns
number
Split and dividend adjusted closing price on the last trading day of the specified month
Examples
=Adjusted_Close_MonthEnd("AAPL", 2025, 6)=Adjusted_Close_MonthEnd("MSFT", 2025, 12)Monthly return:
=(Adjusted_Close_MonthEnd("AAPL",2025,6)-Adjusted_Close_MonthEnd("AAPL",2025,5))/Adjusted_Close_MonthEnd("AAPL",2025,5)When to Use
- Monthly total return calculations
- Building monthly return series for analysis
- Performance attribution at month-end
- Comparing returns across securities with splits
When NOT to Use
\
Common Issues & FAQ
Why does the adjusted close for January change after a March dividend?
Adjusted prices are retroactively recalculated with each new corporate action. This is standard behavior across all financial data providers.
Related Formulas
More MarketXLS Price History formulas you can use in the same worksheet:
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?