1、今天是几号? =DAY(NOW())
=MONTH(NOW())
=WEEKDAY(NOW(),2)
=TODAY()
=YEAR(NOW())
=WEEKNUM(NOW())
=LEN(2^MONTH(NOW()))
=TODAY()-'1-1'+1
=COUPDAYBS(NOW(),'9999-1',4,1)+1
=COUPDAYS(NOW(),'9999-1',4,1)
=INT((DAY(NOW())+MOD(NOW()-DAY(NOW()),7)-1)/7)+1
='12-31'-TODAY()+1 13、本月有多少天? =DAY(EOMONTH(NOW(),0))
=NOW()-DAY(NOW())+1
=EOMONTH(NOW(),0)
=EOMONTH(NOW(),0)-TODAY()
=COUNT(0/(MOD(MONTH(NOW())&-ROW(1:29),7)=6))
=DAY(EOMONTH(NOW(),1))
=DAY(EOMONTH(NOW(),-1))
=NOW()-DAY(NOW())
=WORKDAY(TODAY(),1)
='12-31'-'1-1'+1
=IF(COUNT(-'2-29'),'是','否') 24、2012-6-28出生的宝宝几周岁了? =DATEDIF('2012-6-28',NOW(),'y')
=FLOOR('5-6',7)+8 图文制作:祝洪忠 7月30日9点,函数实战100例正式课第一节准时开始,准备学习函数的同学们,抓紧时间哦! |
|