【练习2】日期函数练习

wy小酒窝

课前练习二
C09:小酒窝
第一题

1. =DAY(TODAY())&"号"

复制代码

第二题

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

复制代码

第三题

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

复制代码

第四题

1. =DATEDIF(TODAY(),DATE(2015,10,31),"D")&"天"

复制代码

第五题

1. =TODAY()-DATE(YEAR(TODAY()),1,)&"天"

复制代码

天天EP

1. 123
   
2. =text(today(),{"D","AAA","MMMM"})
   
3. 4、=EOMONTH(TODAY(),0)-TODAY()
   
4. 5、=TODAY()-EOMONTH(TODAY(),-MONTH(TODAY()))

复制代码

today0427

A05:TODAY0427

1=TODAY()
2="星期"&CHOOSE(WEEKDAY(TODAY(),2),"一","二","三","四","五","六","日")
3=TEXT((MONTH(TODAY())),"mmmm")
4="这个月还有"&DATE(YEAR(NOW()),MONTH(NOW())+1,1)-TODAY()&"天"
5="今天是今年的"&TODAY()-DATE(YEAR(TODAY()),1,1)&"天"

郭郭嗯

{:29:}

antliuliu

A08:antliuliu
第一题：

1. =TODAY()

复制代码

第二题：

1. =WEEKDAY(TODAY(),2)

复制代码

第三题：不会
第四题：

1. =DAY(TODAY())

复制代码

第五题：

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

复制代码

is竝

1.=day(now())    2.=text(today()，"aaaa")  3.=text(today()，"MMMM")       4.=DAY(DATE(YEAR(NOW()),MONTH(NOW())+1,1)-1)–day(now())   5.=TODAY()-"1-1"+2

rlzcjrrmy

2015函初2：A03(rlzcjrrmy)
   1\=DAY(NOW())

   2\=WEEKDAY(NOW(),2)

   3\=TEXT(TODAY(),"[$-409]mmmm;@")

   4\=--TEXT(EOMONTH("2015-10-1",0)-TODAY(),"G/通用格式")

   5\=DATEDIF(TODAY(),"2015-12-31","d")

H明悠

CO8:明悠

1.=DAY(NOW())
2.=WEEKDAY(TODAY(),2)
3.=TEXT(NOW(),"mmmm")
4.=EOMONTH(NOW(),0)-TODAY()+1
  =DAY(EOMONTH(TODAY(),0))-DAY(TODAY())
5.=TODAY()-DATE(YEAR(NOW()),1,1)+1
  =TODAY()-"1-1"+1

米少

A02:米少
1、

1. =day(now())

复制代码

2、

1. =text(now(),"aaaa")

复制代码

3、

1. =text(now(),"mmmm")

复制代码

4、

1. =eomonth(now(),0)-today()

复制代码

5、

1. =today()-"2015-1-1"+1

复制代码

llf0516

1.今天是几号？  =day(now())
2.今天星期几？  =weekday(now(),2)
3.这个月的英文全称怎么写？  =text(now(),"mmmm")
4.这个月还有几天  不会
5.今天是今年的第几天？  不会