Excel求助,=year(today())-year(2009-11-18),结果怎么是104?
Excel求助,=year(today())-year(2009-11-18),结果怎么是104?
excel函数YEAR(TODAY())-YEAR(#REF!)+1
EXCEL的题目=IF(MOD(YEAR(TODAY()),4)=0,IF(MOD(YEAR(TODAY()),100)
excel求年龄 我按照公式 =YEAR(TODAY())-YEAR($C$2)
excel 表格 T9 =DATE(YEAR(TODAY()),MONTH(TODAY()),1) 是这个月的6月1号,
EXCEL求闰年函数=OR(AND(MOD(YEAR(TODAY()),4)=0,MOD(YEAR(TODAY()),1
已知单元格F6为日期格式,2010/2/3,=YEAR(TODAY())-YEAR(F6),结果为1900/1/3怎么回
公式=IF(L8"",YEAR(L8)-YEAR(K8),(YEAR(TODAY())-YEAR(K8)))的复制单元格
.在Excel中如何用year函数和today函数计算年龄.注:这个我试过了,不行吖“=YEAR(TODAY())-YE
用YEAR函数怎么计算Excel年龄
excel的year函数
在excel中YEAR(TODAY())-IF(LEN(C2)=15,"19"&MID(C2,7,2),MID(C2,7