0
Follow
2
View

Why I keep geting my Date wrong on Google Sheets?

ds8341 注册会员
2023-01-25 02:32

the "date" in your D column is a string /plain text you will need to convert it into date with helper column

=ARRAYFORMULA(IFERROR(DATE(LEFT(D2:D; 4); MID(D2:D; 5; 2); RIGHT(D2:D; 2))))

About the Author

Question Info

Publish Time
2023-01-25 02:32
Update Time
2023-01-25 02:32

Related Question

mysql json嵌套数组如何提取其中的值

提问!关于连接池中链接过期的问题(标签-Mysql)

使用——complete-insert导出MySQL数据库时,不会在生成的txt文件中包含列名

如何从MySQL列的HTML中提取文本?

Flask-security-too与wee + mysql不工作

mysql高可用集群搭建

有人可以通过php“mysqli_connect(…)”在输入数据库用户名和密码时注入mysql吗?

通过golang在mysql中插入数据时出现Datetime错误

在谷歌My Business API下列出业务帐户

mysql建表时出现的错误