returns closing history in two columns "Date" and "Close" since Jan. 1, 2021. The date column displays date and time values:

1/4/2021 16:00:00
1/5/2021 16:00:00
1/6/2021 16:00:00
1/7/2021 16:00:00

How do I modify the formula to return only the date and not the time?

  • Have you tried formatting the "Date" column as "Date"?
    – Tedinoz
    Jul 18, 2021 at 2:57

1 Answer 1


Here you go:

=QUERY(GOOGLEFINANCE("NASDAQ:GOOGL","close",date(2021,1,1),today(),1),"select Col1"

Then you go to to 123, which is below the the tools menu and check date. That's it.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.