excel中如何将2021年8月1日 17时21分转换成2021/8/1 17:21?答:B1单元格输入公式=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"年","/"),"月","/"),"日", ),"时",":"),"分", )下拉公式。 如图:示例
如何使用excel函数把日期5/4/2021变成2021/4/5?答:B1公式:=TEXT(DATE(RIGHT(A1,LEN(A1)-FIND("/",SUBSTITUTE(A1,"/","*",1))),MID(A1,FIND("/",A1)+1,FIND("/",SUBSTITUTE(A1,"/","*",1))-FIND("/",A1)-1),LEFT(A1,FIND("/",A1)-1)),"