EXCEL求闰年函数=OR(AND(MOD(YEAR(TODAY()),4)=0,MOD(YEAR(TODAY()),100>0),MOD(YEAR(TODAY()),400)=O),这句话用中文怎么翻译,
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/29 00:59:06
![EXCEL求闰年函数=OR(AND(MOD(YEAR(TODAY()),4)=0,MOD(YEAR(TODAY()),100>0),MOD(YEAR(TODAY()),400)=O),这句话用中文怎么翻译,](/uploads/image/z/1249969-49-9.jpg?t=EXCEL%E6%B1%82%E9%97%B0%E5%B9%B4%E5%87%BD%E6%95%B0%3DOR%28AND%28MOD%28YEAR%28TODAY%28%29%29%2C4%29%3D0%2CMOD%28YEAR%28TODAY%28%29%29%2C100%3E0%29%2CMOD%28YEAR%28TODAY%28%29%29%2C400%29%3DO%29%2C%E8%BF%99%E5%8F%A5%E8%AF%9D%E7%94%A8%E4%B8%AD%E6%96%87%E6%80%8E%E4%B9%88%E7%BF%BB%E8%AF%91%2C)
EXCEL求闰年函数=OR(AND(MOD(YEAR(TODAY()),4)=0,MOD(YEAR(TODAY()),100>0),MOD(YEAR(TODAY()),400)=O),这句话用中文怎么翻译,
EXCEL求闰年函数
=OR(AND(MOD(YEAR(TODAY()),4)=0,MOD(YEAR(TODAY()),100>0),MOD(YEAR(TODAY()),400)=O),这句话用中文怎么翻译,
EXCEL求闰年函数=OR(AND(MOD(YEAR(TODAY()),4)=0,MOD(YEAR(TODAY()),100>0),MOD(YEAR(TODAY()),400)=O),这句话用中文怎么翻译,
首先,闰年的计算方式是:
能被4整除且又不能被100整除 是闰年;
能直接被400整除也是闰年.
所以,这个公式是这样解释的:today()是取今天的日期;
year(today())是取今天所属的年,这里得到的就是 2014 ;
mod(year(Today()),4)=0 是表示今天所属的年能被4整除为 true,不能为 false;
同理mod(year(Today()),100)>0 【你这里在100后面少了一个“)”,】是表示今天所属的年不能被100整除为true,能为 false;
And(mod(year(Today()),4)=0 , mod(year(Today()),100)>0 )就是这两个条件要同时满足,也就是上面提到的第一点:能被4整除且又不能被100整除 是闰年;
同理,MOD(YEAR(TODAY()),400)=0 【注意这里应该是0,而不是 O】是表示今天所属的年能被400整除为 true,不能为 false;也就是上面提到的第二点:能直接被400整除也是闰年.
Or(AND(MOD(YEAR(TODAY()),4)=0,MOD(YEAR(TODAY()),100)>0),MOD(YEAR(TODAY()),400)=0) 就是这两个条件任一一个满足即可.
明白了吗?