Google-sheets – Entering new date in a column does not autoformat

google sheets

I've already done Format > Number > More Formats > More Date and Time formats for the entire column but the new date entries are still not auto formatted, how can I make it auto format?

Here's the spreadsheet:
https://docs.google.com/spreadsheets/d/1O1rZUstDNSXPdUVXvaDfPO4rAQs2cJWHimfGxbddtNU/edit#gid=0

Best Answer

select A7 cell
press CTRL + C
select A8 cell or A8:A range
press CTRL + LEFT ALT + V

to make it automatic after you pre-format the range you need to input hours too like:
```
2/2 8:00
```
5/28 0:00
etc.

Related Solutions

Google Sheets – How to Format Date

This will fix it for you:

=text(regexreplace("timestamp","^\w{3},",""),"MM/DD/YYYY")

you could also transform to remove the additional time parameter at the end with this:

=text(regexreplace(regexreplace("timestamp","^\w{3}, ",""), ", \d+:\d+\w+",""),"MM/DD/YYYY")

OR if your data consistently is formatted the way you did in your examples (with the commas present) you can simply do this:

=TEXT(REGEXEXTRACT(C10,",(.*),"),"MM/DD/YYYY")

Google Sheets – Get Halfway Date Between Two Dates

To find the number that's halfway between A2 and B2, use the formula

=(A2+B2)/2

(You'll need to apply a suitable date format to the output.)

Best Answer

Related Solutions

Google Sheets – How to Format Date

Google Sheets – Get Halfway Date Between Two Dates

Related Topic