我想请问 =YEAR(TODAY())-MID(F12,7,4)这个公式的语法姚怎么描述、谢谢

我想请问 =YEAR(TODAY())-MID(F12,7,4)这个公式的语法姚怎么描述、谢谢 =ABS(DATE(YEAR(TODAY()),MONTH($B2),DAY($B2))-TODAY()) Today school year 谁能帮忙改个公式 =ABS(DATE(YEAR(TODAY()),MONTH($G3),DAY($G3))-TODAY()) Excel求助,=year(today())-year(2009-11-18),结果怎么是104? excel函数YEAR(TODAY())-YEAR(#REF!)+1 .在Excel中如何用year函数和today函数计算年龄.注：这个我试过了,不行吖“=YEAR(TODAY())-YEAR(A1)” A Year Ago Today 歌词 A Year Ago Today 歌词 in one year from today 帮莪解释一下这个excel生日提醒公式吧~=IF(DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))=TODAY(),今天,&DATE(IF(DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))>=TODAY(),YEAR(TODAY()),YEAR(TODAY())+1),MONTH(B2),DAY(B2))-TODAY()&天)解释一下什么 帮莪解释一下这个excel生日提醒公式吧~=IF(DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))=TODAY(),今天,&DATE(IF(DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))>=TODAY(),YEAR(TODAY()),YEAR(TODAY())+1),MONTH(B2),DAY(B2))-TODAY()&天)解释一下什么 公式=IF(L8,YEAR(L8)-YEAR(K8),(YEAR(TODAY())-YEAR(K8)))的复制单元格中怎样去掉111excel计算工龄 关于pb时间表达式的问题int jd,rqif month(today())>=1 and month(today())=4 and month(today())=7 and month(today())=10 and month(today())=year(today()).01.01 and rq EXCEL的题目=IF(MOD(YEAR(TODAY()),4)=0,IF(MOD(YEAR(TODAY()),100)=0,IF(MOD(YEAR(TODAY()),400)=0,闰年,平年),闰年),平年）这里每个if的内容是什么 太混乱了 EXCEL求闰年函数=OR(AND(MOD(YEAR(TODAY()),4)=0,MOD(YEAR(TODAY()),100>0),MOD(YEAR(TODAY()),400)=O),这句话用中文怎么翻译, 公式“=(YEAR(TODAY())-YEAR(B8))*12+(MONTH(TODAY())-MONTH(B8))-1”引用的是哪里的日期?如果我要引用F2里的日期呢? excel用时间函数计算年龄我很困惑,计算年龄要不要考虑月份的啊?我看到两种答案一是：=YEAR(TODAY())-YEAR(C2)；另一种是：=YEAR(TODAY())-YEAR(A2)+IF(MONTH(TODAY())-MONTH(A2)>=0,0,-1)+IF(DAY(TODAY())-DAY(A2)>=0,0,-1)