如何在excel中得出一个单元格内两个日期间隔的天数?
例如A1单元格里面是2018.01.01-2018.01.08 怎么快速用函数得出相隔天数在A2单元格
=substitute(right(a1,len(a1)-find("-",a1)),".","-")-SUBSTITUTE(LEFT(A1,FIND("-",A1)-1),".","-")
热门标签:
例如A1单元格里面是2018.01.01-2018.01.08 怎么快速用函数得出相隔天数在A2单元格
=substitute(right(a1,len(a1)-find("-",a1)),".","-")-SUBSTITUTE(LEFT(A1,FIND("-",A1)-1),".","-")