CODEWITHSUNDEEP
dategoogle-sheetsgoogle-sheets-formulagoogle-formsarray-formulas
Carlos Craig
Carlos Craig

Reputation: 151

how to convert date and time to just date in Sheets

I use Google Forms to import data from a signup form to Google Sheets, and it gives time and date stamp, I just want it to give a date and not the time.

enter image description here

Upvotes: 0

Views: 63

Answers (2)

player0
player0

Reputation: 1

you can also do:

=ARRAYFORMULA(INDEX(SPLIT(B2:B, " "),,1)

or even like this:

=ARRAYFORMULA(TO_DATE(DATEVALUE(B2:B)))

Upvotes: 1

Carlos Craig
Carlos Craig

Reputation: 151

Figured it out. This formula works perfect

=MONTH(A2) & "/" & DAY(A2) & "/" & YEAR(A2)

Hope this helps someone.

Upvotes: 0

Related Questions