2020.1.1-2020.3.20号,如何算2020.3.1-2020.3.20有多少天啊?_百度知 ...答:"/"))),"d")+1公式二(先计算起始时间再替换):=DATEDIF(SUBSTITUTE(LEFT(G4,FIND("-",G4)-1),".","/"),SUBSTITUTE(RIGHT(G4,LEN(G4)-FIND("-",G4)),".","/"),"d")+1 难点是原格式是2020.1.1,非日期格式,需要将.替换为/。实际效果如图:更具需求修改:=TEXT(RIGHT(...