Excel求助,=year(today())-year(2009-11-18),结果怎么是104?

Excel求助,=year(today())-year(2009-11-18),结果怎么是104? excel函数YEAR(TODAY())-YEAR(#REF!)+1 .在Excel中如何用year函数和today函数计算年龄.注：这个我试过了,不行吖“=YEAR(TODAY())-YEAR(A1)” 公式=IF(L8,YEAR(L8)-YEAR(K8),(YEAR(TODAY())-YEAR(K8)))的复制单元格中怎样去掉111excel计算工龄 帮莪解释一下这个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()&天)解释一下什么 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),这句话用中文怎么翻译, 求excel函数两个条件匹配的写法已知：=IF((DATE(YEAR(F3),MONTH(F3),DAY(F3))-TODAY()) EXCEL判断闰年,看看我这个公式哪里错了=IF(OR(AND(MOD(YEAR(TODAY()),4)=0,MOD(YEAR(TODAY()),100)0),MOD(YEAR(YODAY()),400=0),闰年,平年) 说我少了一个括号 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) 请求Excel专家对if条件函数：=IF(DATEDIF(TODAY(),DATE(YEAR(C6)+3,MONTH(C6),DAY(C6)),y)=0,,DATEDIF(TODAY(),DATE(YEAR(C6)+3,MONTH(C6),DAY(C6)),y)&年)&&IF(DATEDIF(TODAY(),DATE(YEAR(C6)+3,MONTH(C6),DAY(C6)),ym)=0,IF(DATEDIF(TODAY(),D =DAY(TODAY())/DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0))谁能帮忙解答下这个excel中的时间占比公式每一部分的具体含义呢?后面看不太明白 =TODAY() EXCEL表格公式 什么意思? =ABS(DATE(YEAR(TODAY()),MONTH($B2),DAY($B2))-TODAY()) 求解excel提醒涵数A1格输入待办事A2格输入办日期 (2013年1月26日的日期格式)A3格输入以下涵数:=IF(DATE(YEAR(TODAY()),MONTH(C7),DAY(C7))-TODAY()>=0,IF(DATE(YEAR(TODAY()),MONTH(C7),DAY(C7))-TODAY()>=0,今天到期,IF(DATE(Y excel 表格 T9 =DATE(YEAR(TODAY()),MONTH(TODAY()),1) 是这个月的6月1号,=DAYS360(T9,TODAY())=DAYS360(T9,TODAY()) 这俩个公示我一起用,但是在月初的时候 就变成是0天了,我想要的是五月的最后一天,以此类推.怎么 Today school year