谁能帮我分析一下这个函数的由来?=DATE(RIGHT(RIGHT(A1,LEN(A1)-FIND("/",A1)),LEN(RIGHT(A1,LEN(A1)-FIND("/",A1)))-FIND("/",RIGHT(A1,LEN(A1)-FIND("/",A1)))),LEFT(A1,FIND("/",A1)-1),LEFT(RIGHT(A1,LEN(A1)-FIND("/",A1)),FIND("/",RIGHT(A1,LEN(A
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/02 00:55:01
![谁能帮我分析一下这个函数的由来?=DATE(RIGHT(RIGHT(A1,LEN(A1)-FIND(](/uploads/image/z/8772059-11-9.jpg?t=%E8%B0%81%E8%83%BD%E5%B8%AE%E6%88%91%E5%88%86%E6%9E%90%E4%B8%80%E4%B8%8B%E8%BF%99%E4%B8%AA%E5%87%BD%E6%95%B0%E7%9A%84%E7%94%B1%E6%9D%A5%3F%3DDATE%28RIGHT%28RIGHT%28A1%2CLEN%28A1%29-FIND%28%22%2F%22%2CA1%29%29%2CLEN%28RIGHT%28A1%2CLEN%28A1%29-FIND%28%22%2F%22%2CA1%29%29%29-FIND%28%22%2F%22%2CRIGHT%28A1%2CLEN%28A1%29-FIND%28%22%2F%22%2CA1%29%29%29%29%2CLEFT%28A1%2CFIND%28%22%2F%22%2CA1%29-1%29%2CLEFT%28RIGHT%28A1%2CLEN%28A1%29-FIND%28%22%2F%22%2CA1%29%29%2CFIND%28%22%2F%22%2CRIGHT%28A1%2CLEN%28A)
谁能帮我分析一下这个函数的由来?=DATE(RIGHT(RIGHT(A1,LEN(A1)-FIND("/",A1)),LEN(RIGHT(A1,LEN(A1)-FIND("/",A1)))-FIND("/",RIGHT(A1,LEN(A1)-FIND("/",A1)))),LEFT(A1,FIND("/",A1)-1),LEFT(RIGHT(A1,LEN(A1)-FIND("/",A1)),FIND("/",RIGHT(A1,LEN(A
谁能帮我分析一下这个函数的由来?
=DATE(RIGHT(RIGHT(A1,LEN(A1)-FIND("/",A1)),LEN(RIGHT(A1,LEN(A1)-FIND("/",A1)))-FIND("/",RIGHT(A1,LEN(A1)-FIND("/",A1)))),LEFT(A1,FIND("/",A1)-1),LEFT(RIGHT(A1,LEN(A1)-FIND("/",A1)),FIND("/",RIGHT(A1,LEN(A1)-FIND("/",A1)))-1))这是把文本格式转化为日期的函数.
谁能帮我分析一下这个函数的由来?=DATE(RIGHT(RIGHT(A1,LEN(A1)-FIND("/",A1)),LEN(RIGHT(A1,LEN(A1)-FIND("/",A1)))-FIND("/",RIGHT(A1,LEN(A1)-FIND("/",A1)))),LEFT(A1,FIND("/",A1)-1),LEFT(RIGHT(A1,LEN(A1)-FIND("/",A1)),FIND("/",RIGHT(A1,LEN(A
只能一个一个地解释.
date(年,月,日):返回日期格式
len(字符串):字符串的长度
find(查找内容,查找内容所在字符串):查找内空在字符串的第几位.
right(字符串,从右至左截取几位):内容截取,方向右至左
left(字符串,从左至右截取几位):内容截取,方向左至右
将其分段来看:
年:RIGHT(RIGHT(A1,LEN(A1)-FIND("/",A1)),LEN(RIGHT(A1,LEN(A1)-FIND("/",A1)))-FIND("/",RIGHT(A1,LEN(A1)-FIND("/",A1))))
月:LEFT(A1,FIND("/",A1)-1)
日:LEFT(RIGHT(A1,LEN(A1)-FIND("/",A1)),FIND("/",RIGHT(A1,LEN(A1)-FIND("/",A1)))-1)
最后利用date函数将其返回的三个数值组成一个日期.
其实也可以改为:
=TEXT(DATE(MID(A1,FIND("/",A1,4)+1,4),MID(A1,FIND("/",A1)+1,FIND("/",A1,FIND("/",A1)+1)-FIND("/",A1)-1),LEFT(A1,FIND("/",A1,1)-1)),"e-m-d")