New answers tagged

-1 votes

How to get close price for last date market was open?

The correct answer is to use the Workday() function as follows: =Index(GOOGLEFINANCE("MSFT","price", Workday(DateValue("12/31/2023")+1,-1)),2,2)
Randall's user avatar

Top 50 recent answers are included