【开贴啦】【函中 201401】练习10-日期函数（2）

jio1ye

zhangrongmei 发表于 2014-8-4 15:35
我下载了打不开

请问你是用几年版本的？我附件了一个03版本的给你用看看。 习题10-日期函数（2）.rar (7.2 KB, 下载次数: 2)

2014-8-4 21:24 上传

点击文件名下载附件

cgzxwwf

cgzxwwf 发表于 2014-8-3 15:43
才疏学浅，拼凑了半天终于有结果了，只不过公式比较长。第二题用了条件格式，请指导

日期突破记录啦。。哈哈。。

contending

1. 1、IF((A5-WEEKDAY(A5,2)+3)<A5,TEXT((A5-WEEKDAY(A5,2)+4),"m月d日")&"~"&TEXT((A5-WEEKDAY(A5,2)+10),"m月d日"),TEXT((A5-WEEKDAY(A5,2)-3),"m月d日")&"~"&TEXT((A5-WEEKDAY(A5,2)+3),"m月d日"))
   
2. 2.1.1、RANDBETWEEN(2001,2021)
   
3. 或 开发工具-吃插入-表单控件-数值调节钮---设置控件格式
   
4. 2.1.2、条件格式-新建规则-公式-=YEAR(TODAY())&MONTH(TODAY())=$A$15&$C$15-黄色
   
5. 2.2、IF(DAY(DATE($A$15,$C$15+1,0))>=(ROW()-ROW($A$16))*7+COLUMN()-COLUMN($A$16)+1,(ROW()-ROW($A$16))*7+COLUMN()-COLUMN($A$16)+1,"")
   
6. 2.3、

复制代码

air05

{:011:}来交作业了美女组长

Excel学徒123

第一个找不到入手点啊

车仁静

交练习~~~~~

ldxhzy

练习10.

meililin

只会1小题，而且相当冗长

1. b2=CHOOSE(WEEKDAY(TODAY(),14),TEXT(TODAY(),"M月d日")&"~"&TEXT(TODAY()+6,"M月d日"),TEXT(TODAY()-1,"M月d日")&"~"&TEXT(TODAY()+5,"M月d日"),TEXT(TODAY()-2,"M月d日")&"~"&TEXT(TODAY()+4,"M月d日"),TEXT(TODAY()-3,"M月d日")&"~"&TEXT(TODAY()+3,"M月d日"),TEXT(TODAY()-4,"M月d日")&"~"&TEXT(TODAY()+2,"M月d日"),TEXT(TODAY()-5,"M月d日")&"~"&TEXT(TODAY()+1,"M月d日"),TEXT(TODAY()-6,"M月d日")&"~"&TEXT(TODAY(),"M月d日"))

复制代码

满坛皆为吾师

E15-满坛皆为吾师.rar (12.46 KB, 下载次数: 2)

2014-8-6 19:54 上传

点击文件名下载附件

jio1ye

+++++++++++++++++++++++++++++本楼以下不再评分++++++++++++++++++++++++++++++++++{:031:}