Skip to main content


Get the past, present, or future status for a stock market for a single date or multiple dates. The formula will respond with "open" for trading days or "closed" for weekends or market holidays.

Sample Usage



=MARKETSTATUS(country, [attributes], start date, end date)
  • country (OPTIONAL) The two-letter country code. Currently only the US is supported.

  • [attributes] (OPTIONAL) Use one or more of the following attributes:

    • "date" – The date that the market was either open or closed.
    • "status" – The status of the market, either open or closed.
    • "all" – Returns all values.
  • start date (OPTIONAL) The start date when fetching the market's status. If start date is specified, but end date is not, only the single day’s data is returned.

  • end date (OPTIONAL) The end date when fetching the market's status, or the number of calendar days (not trading days) from the start date from which to return data.


  • All parameters must be enclosed in quotation marks or be references to cells containing text. A possible exception is when end date is specified as a number of days.