您的位置: 首页 > 作业答案 > 其他 > =DATEDIF(TEXT(SUBSTITUTE(2007.10,".","-"),"yyyy-mm"),TODAY(),"y")

=DATEDIF(TEXT(SUBSTITUTE(2007.10,".","-"),"yyyy-mm"),TODAY(),"y")

分类: 作业答案 • 2022-06-29 19:51:00

问题描述：

=DATEDIF(TEXT(SUBSTITUTE(2007.10,".","-"),"yyyy-mm"),TODAY(),"y")

答

计算2007年10月距离今天有几年的差距