2
=GOOGLEFINANCE("NASDAQ:GOOGL","close",date(2021,1,1),today(),1)

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?

1/4/2021
1/5/2021
1/6/2021
1/7/2021
1
  • Have you tried formatting the "Date" column as "Date"?
    – Tedinoz
    Jul 18, 2021 at 2:57

1 Answer 1

-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, privacy policy and cookie policy

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