函入班第5讲12组上交作业帖

花木兰 · 发表于 2008-7-1 00:30

游客，如果您要查看本帖隐藏内容请回复

第一题：多出一天。 第三题：本周有些日期不会提示“本周生日”。试试周六的日期。 第七题：不正确。换其它年份测试一下。     By:  L.H.

[此贴子已经被jyh197994于2008-7-3 17:00:13编辑过]

莫欣 · 发表于 2008-7-1 00:46

游客，如果您要查看本帖隐藏内容请回复

交作业=DATE(B1,6,1)+2*7+IF(WEEKDAY(DATE(B1,6,1),1)<2,0,7-WEEKDAY(DATE(B1,6,1),1)+1)'=DATE(B1,6,1)+2*7+IF(WEEKDAY(DATE(B1,6,1),1)<2,0,7-WEEKDAY(DATE(B1,6,1),1)+1) <table cellspacing="0" cellpadding="0" width="339" border="0" xstr="" style="WIDTH: 254pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="120" style="WIDTH: 90pt; mso-width-source: userset; mso-width-alt: 3840;"></col><col></col><col width="147" style="WIDTH: 110pt; mso-width-source: userset; mso-width-alt: 4704;"></col><col></col><col width="72" style="WIDTH: 54pt;"></col><col></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td width="339" colspan="3" height="19" xstr="'=DATEDIF(TODAY(),DATE(IF(DATE(YEAR(TODAY()),MONTH(A2),DAY(A2))-TODAY()>0,YEAR(TODAY()),YEAR(TODAY())+1),MONTH(A2),DAY(A2)),"d")" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 254pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"><table cellspacing="0" cellpadding="0" width="339" border="0" xstr="" style="WIDTH: 254pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="120" style="WIDTH: 90pt; mso-width-source: userset; mso-width-alt: 3840;"></col><col></col><col width="147" style="WIDTH: 110pt; mso-width-source: userset; mso-width-alt: 4704;"></col><col></col><col width="72" style="WIDTH: 54pt;"></col><col></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td width="339" colspan="3" height="19" xstr="'=DATEDIF(TODAY(),DATE(IF(DATE(YEAR(TODAY()),MONTH(A2),DAY(A2))-TODAY()>0,YEAR(TODAY()),YEAR(TODAY())+1),MONTH(A2),DAY(A2)),"d")" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 254pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan;">1题=DATEDIF(TODAY(),DATE(IF(DATE(YEAR(TODAY()),MONTH(A2),DAY(A2))-TODAY()>0,YEAR(TODAY()),YEAR(TODAY())+1),MONTH(A2),DAY(A2)),"d")<table cellspacing="0" cellpadding="0" width="262" border="0" xstr="" style="WIDTH: 197pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="262" style="WIDTH: 197pt; mso-width-source: userset; mso-width-alt: 8384;"></col><col></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td width="262" height="19" xstr="'=IF(AND(MONTH(TODAY())=MONTH(A2),DATE(YEAR(TODAY()),MONTH(A2),DAY(A2))-TODAY()>=0),"还差"&(DATE(YEAR(TODAY()),MONTH(A2),DAY(A2))-TODAY())&"天生日","")" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 197pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">2题=IF(AND(MONTH(TODAY())=MONTH(A2),DATE(YEAR(TODAY()),MONTH(A2),DAY(A2))-TODAY()>=0),"还差"&(DATE(YEAR(TODAY()),MONTH(A2),DAY(A2))-TODAY())&"天生日","")3题：不会4题=(B3-A3)*24*605题="NO."&REPT(0,10-LEN(A3))&A3</td></tr></tbody></table> 6题：不会</td></tr></tbody></table>7题=DATE(B1,6,1)+2*7+IF(WEEKDAY(DATE(B1,6,1),1)<2,0,7-WEEKDAY(DATE(B1,6,1),1)+1)8题=LEFT(A2)&IF(MOD(VALUE(MID(A2,2,1)),2)=0,3,8)&RIGHT(A2,LEN(A2)-1)</td></tr></tbody></table> [/hide][em04]做出来都能通过。不会的，态度也诚恳。第二题还能计算出有多少天过生日。[em17]父亲节计算都没有问题，第六题应该不是你想的那样难。参考别人的思路再练习一下！                                                                                                                       By:  L.H.

[此贴子已经被jyh197994于2008-7-3 17:11:23编辑过]

和田玉 · 发表于 2008-7-1 14:59

游客，如果您要查看本帖隐藏内容请回复

学习一下，谢谢！

和田玉 · 发表于 2008-7-1 15:02

4题：(B3-A3)*24*605题："NO."&TEXT(A2,"0000000000") 我的其他题不对，没法上交了。汗！[em04]注意用回复帖!  此两题通过! 能做多少算多少,可以学习一下其他学友的思路.           by: L.H.

[此贴子已经被jyh197994于2008-7-3 17:13:42编辑过]

庆宝宝 · 发表于 2008-7-1 17:53

[em01]

jyh197994 · 发表于 2008-7-2 19:17

[em01]

别具匠心 · 发表于 2008-7-4 23:55

未上课  学习一下

风1234 · 发表于 2008-7-8 11:48

学习，学习！

和田玉 · 发表于 2008-7-18 23:28

谢谢老师！

sunshine-jn · 发表于 2008-7-19 21:00

學習學習[em05]

		自动登录	找回密码
密码			注册

[通知] 函入班第5讲12组上交作业帖

浏览过的版块