【练习2】日期函数练习

qiaoqiaodl_001

201502函初A07:qiaoqiaodl_001
第一题        =TODAY()
第二题        =WEEKDAY(NOW(),2)
第三题        =TEXT(NOW(),"[$-809]mmmm;@")
第四题        =DATE(YEAR(NOW()),MONTH(NOW())+1,)-TODAY()
第五题        =TODAY()-DATE(YEAR(NOW()),MONTH(1),DAY(1))

thelastdance

1. =TODAY()

复制代码

1. =TEXT(TODAY(),"aaaa")

复制代码

1. =TEXT(TODAY(),"mmmm")

复制代码

1. =EOMONTH(NOW(),0)-TODAY()

复制代码

1. =TODAY()-DATE(YEAR(TODAY()),1,1)

复制代码

jzkwf

C组长:jzkwf

1.今天是几号？

1. =Day(TODAY())

复制代码

2.今天星期几？

1. =TEXT(TODAY(),"aaaa")
   
2. =TEXT(TODAY(),"aaa")
   
3. =TEXT(TODAY(),"dddd")
   
4. =TEXT(TODAY(),"ddd")
   
5. =WEEKDAY(NOW(),2)

复制代码

3.这个月的英文全称怎么写？

1. =TEXT(NOW(),"mmmm")

复制代码

4.这个月还有几天？

1. =EOMONTH(NOW(),0)-TODAY()

复制代码

5.今天是今年的第几天？

1. =TODAY()-"1-1"+1

复制代码

回答完毕！

绵花糖

1. 1.今天是几号？  
   
2. =DAY(NOW())&"号"
   
3. 2.今天星期几？   
   
4. =TEXT(NOW(),"aaaa")
   
5. 3.这个月的英文全称怎么写？ TEXT(MONTH(NOW()),"mmmm")
   
6. 4.这个月还有几天
   
7. =EOMONTH(NOW(),0)-TODAY()
   
8. 5.今天是今年的第几天？
   
9. =TODAY()-DATE(YEAR(NOW()),1,)

复制代码

{:26:}交作业了，以上公式的now()均可换成today(),为省字符嘿嘿~~你懂得

皮皮2

1.

1. =TODAY()

复制代码

2.

1. =TEXT(TODAY(),"aaaa")

复制代码

3.

1. =TEXT(TODAY(),"MMMM")

复制代码

4.

1. =DAYS(DATE(2015,10,31),TODAY())

复制代码

5.

1. =TODAY()-42005

复制代码

suzhouy2003

201502函初班：A10

1.="今天是"&DAY(TODAY())&"号"
2.="本月英文全称："&TEXT(MONTH(TODAY()),"mmmm")
3.="今天星期"&WEEKDAY(TODAY())
4.="本月还有"&DAYS360(TODAY(),EOMONTH(TODAY(),0))&"天"
5.="今天是今年的第"&DAYS360(EOMONTH(TODAY(),-MONTH(TODAY())),TODAY())&"天"

vicky4896

C03:vicky4896
1.

1. =TODAY()

复制代码

2.

1. =TEXT(TODAY(),"aaaa")

复制代码

3.

1. =TEXT(TODAY(),"mmmm")

复制代码

4.

1. =EOMONTH(TODAY(),0)-TODAY()

复制代码

5.

1. =TODAY()-DATE(2015,1,1)

复制代码

句号1234

1、=TODAY()；
2、=WEEKDAY(TODAY(),1)；
3、=TEXT(TODAY(),"mmmm")；
4、=EOMONTH(TODAY(),0)-TODAY()；
5、=TODAY()-EOMONTH(TODAY(),-MONTH(TODAY()))

gyp0707

1：TODAY()
2：WEEKDAY(TODAY(),2)
3：TEXT(B1,"mmmmmmm")
4：DATEDIF(TODAY(),"2015-10-31","D")
5：YEARFRAC(B1,2015-10-31,3)[/code]

fjmxwrs

1. =DAY(TODAY())

复制代码

1. =TEXT(WEEKDAY(TODAY()),"aaaa")

复制代码

1. =TEXT(TODAY(),"mmm")

复制代码

1. =DATE(YEAR(TODAY()),MONTH(TODAY())+1,0)-TODAY()

复制代码

1. =TODAY()-DATE(YEAR(TODAY()),1,1)

复制代码