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
    Commented 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 you have read our privacy policy.

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