请教：如何计算两个日期的年、月、日数

liuliuq

比如：2013/1月/12日，2018/3月/10日，两个日期差多少年、多少月、多少日？谢谢！求教

liuliuq

补充一下：想要的结果是，2013/1月/12日，2018/3月/10日这两个日期之间相差5年1月26天。

MRnightf

=DATEDIF(LEFT(SUBSTITUTE(A1,"/",""),4)&"年"&RIGHT(SUBSTITUTE(A1,"/",""),LEN(SUBSTITUTE(A1,"/",""))-4),LEFT(SUBSTITUTE(B1,"/",""),4)&"年"&RIGHT(SUBSTITUTE(B1,"/",""),LEN(SUBSTITUTE(B1,"/",""))-4),"y")&"年"&DATEDIF(LEFT(SUBSTITUTE(A1,"/",""),4)&"年"&RIGHT(SUBSTITUTE(A1,"/",""),LEN(SUBSTITUTE(A1,"/",""))-4),LEFT(SUBSTITUTE(B1,"/",""),4)&"年"&RIGHT(SUBSTITUTE(B1,"/",""),LEN(SUBSTITUTE(B1,"/",""))-4),"ym")&"月"&DATEDIF(LEFT(SUBSTITUTE(A1,"/",""),4)&"年"&RIGHT(SUBSTITUTE(A1,"/",""),LEN(SUBSTITUTE(A1,"/",""))-4),LEFT(SUBSTITUTE(B1,"/",""),4)&"年"&RIGHT(SUBSTITUTE(B1,"/",""),LEN(SUBSTITUTE(B1,"/",""))-4),"md")&"日"
思路这样，先把他转化成年月日格式，如c1，d1，然后用DATEIF