【函中20130301】第十一讲C组作业上交帖【开贴】

cir.s

【函中20130301】C12-Cir.s    学委，只会这么多了{:14:}
第一题         =TEXT(--TEXT(MID(B203,1,FIND(" ",B203)),"e年mm月dd日")+TIMEVALUE(TEXT(MID(B203,FIND(" ",B203)+1,100),"上午/下午h时mm分ss秒")),"e年mm月dd日上午/下午h时mm分ss秒")
第二题         =TEXT(B213&1,"m")
第三题         =TEXT(MID(C222,1,FIND("/",C222)-1)&TEXT(MID(C222,FIND("/",C222)+1,FIND("/",C222,FIND("/",C222)+1)-FIND("/",C222)-1)&"/1","mmm")&MID(C222,FIND("/",C222,FIND("/",C222)+1)+1,5),"yyyy-m-d")
第四题         =TEXT(IF(WEEKDAY(C237,2)>3,C237+7-WEEKDAY(C237,2),C237-WEEKDAY(C237,2)),"e-m-d")
第五题
第六题

不信这样不重名

不信这样不重名
时间紧急，直接上附件了，第5题太纠结了，待看讲解
11讲作业.rar (57.04 KB, 下载次数: 5)

2013-7-19 16:25 上传

点击文件名下载附件

womohe

函中201301-C18-womohe


1 =TEXT(LEFT(B303,FIND(" ",B303))+SUBSTITUTE(RIGHT(B303,LEN(B303)-FIND(" ",B303))," ",""),"yyyy年mm月dd日上午/下午hh时mm分ss秒")
2 =MONTH(B313&1)
3 =TEXT(RIGHT(C322,LEN(C322)-FIND("/",C322,4))&-MID(C322,FIND("/",C322)+1,FIND("/",C322,4)-FIND("/",C322)-1)&-LEFT(C322,FIND("/",C322)-1),"e-m-d")
4 =IF(WEEKDAY(C337,2)>3,C337+7-WEEKDAY(C337,2),C337-WEEKDAY(C337,2))
5 =MONTH(SUBSTITUTE(IF(AND(COUNT(FIND({".","-","月"},C346))=0,LEN(C346)<5),TEXT(C346,"00-00"),C346),".","-"))
6 =--(C$360&"-1-1")+7-WEEKDAY(C$360&"-1-1",2)+7*(D$360-2)+ROW(A1)

pang1688

【函中201301班】-C14-pang1688
1、不会
2、不会
3、

1. =TEXT(SUBSTITUTE(E322,F322,"")&"/"&MID(E322,1,FIND("/",E322))&MID(C322,1,FIND("/",C322)-1),"e-mm-dd")

复制代码

4、

1. =IF(WEEKDAY(C337,2)>=4,C337-WEEKDAY(C337,2)+7,C337-WEEKDAY(C337,2))

复制代码

5、

1. =IF(AND(ISNUMBER(C346),C346<1500),IF(ISNUMBER(FIND(".",C346)),MID(C346,1,FIND(".",C346)-1),MID(C346,1,LEN(C346)-LEN(RIGHT(C346,2)))),TEXT(C346,"m"))

复制代码

6、不会。

yjeeee

【函中201301班】-C07-yjeeee
提交晚了，请学委点评，谢谢！

1

1. =TEXT(LEFT(B303,FIND(" ",B303))+TIMEVALUE(RIGHT(B303,LEN(B303)-FIND(" ",B303))),"yyyy年m月d日上午/下午h时mm分ss秒;@")

复制代码

2

1. =MONTH(23&B313)

复制代码

3

1. =DATE(TEXT(LEN(RIGHT(C322,LEN(C322)-FIND("/",SUBSTITUTE(C322,"/","-",1)))),"[=1]2!0!0;[=2]2!0;!0")&RIGHT(C322,LEN(C322)-FIND("/",SUBSTITUTE(C322,"/","-",1))),MID(C322,FIND("/",C322)+1,FIND("/",SUBSTITUTE(C322,"/","-",1))-FIND("/",C322)-1),LEFT(C322,FIND("/",C322)-1))

复制代码

4

1. =TEXT(IF(WEEKDAY(C337,2)<4,C337-WEEKDAY(C337,2),C337+(7-WEEKDAY(C337,2))),"yyyy-m-d;@")

复制代码

5

1. =TEXT(IF(OR(TYPE(C346)=2,C346>40000),C346,IF(IFERROR(FIND(".",C346),500)<100,SUBSTITUTE(C346,".","-"),TEXT(C346,"0-00"))),"m")

复制代码

6

1. =TEXT(DATE($C$360,1,1)+ROW(A1)+WEEKDAY($C$360&"-1-1",2)+($D$360-2)*7,"m/d")

复制代码