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

馨怡

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

</p><p>第一题:=IF(TEXT(A2,"mm-dd")&gt;=TEXT(TODAY(),"mm-dd"),TEXT(A2,"mm-dd")-TEXT(TODAY(),"mm-dd"),DATE(YEAR(TODAY())+1,MONTH(A2),DAY(A2))-TEXT(TODAY(),"yyyy-mm-dd"))</p><p>第二题:=IF(AND(MONTH($A2)=MONTH(TODAY()),DAY($A2)&gt;=DAY(TODAY())),"距离生日还有"&amp;DAY($A2)-DAY(TODAY())&amp;"天","")</p><p>第四题:=(B3-A3)*24*60</p><p>第五题:=TEXT(A2,"!NO!.0000000000")</p><p>第六题:=TEXT(A2,"YYYY-M-D"),=TEXT(A2,"h:mm")</p><p>第七题:=DATE(YEAR(TODAY()),6,22)-WEEKDAY(DATE(YEAR(TODAY()),6,1),2)</p><p>第八题:=IF(MOD(MID(A2,2,1),2)=1,REPLACE(A2,2,0,8),REPLACE(A2,2,0,3))</p><p><font color="#ff1111">第三题未做,其它PASS.注意回复帖的用法!&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; by:L.H.</font></p><p>&nbsp;</p>

[此贴子已经被jyh197994于2008-7-4 4:36:10编辑过]

奔驰列车

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

</p><p><font color="#ff0000">第二题,第三题有辅助单元格?引用位置不对.第六题要自设格式,不能算正确.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; By: L.H.</font></p>

[此贴子已经被jyh197994于2008-7-4 4:41:25编辑过]

liuyingzi28

<p>

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

[em06]</p><p><font color="#ff1111">第一,三,六题不正确.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; by:L.H.</font></p>

[此贴子已经被jyh197994于2008-7-4 4:47:11编辑过]

黛黛

这次作业有点吃力!

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

</p><p><font color="#ff1111">第三题不正确. 另外要注意贴首个公式,否则引用错误.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; By: L.H.</font></p>

[此贴子已经被jyh197994于2008-7-4 4:52:12编辑过]

amw9422585

<p>1=IF(DATE(YEAR(TODAY()),MONTH(A2),DAY(A2))&gt;TODAY(),DATE(YEAR(TODAY()),MONTH(A2),DAY(A2))-TODAY(),DATE(YEAR(TODAY())+1,MONTH(A2),DAY(A2))-TODAY())</p><p>2=IF(AND(MONTH(A2)=MONTH(TODAY()),DAY(A2)&gt;=DAY(TODAY())),"本月过生日","")</p><p>3=IF(AND(WEEKNUM(A2)=WEEKNUM(TODAY()),DAY(A2)&gt;=DAY(TODAY())),"本周生日","")</p><p>4=(B3-A3)*24*60</p><p>5=TEXT(A2,"!NO!.0000000000")</p><p>6=YEAR(A2)&amp;"-"&amp;MONTH(A2)&amp;"-"&amp;DAY(A2)&nbsp;&nbsp; =TEXT(A2,"h:mm")</p><p>7=DATE(YEAR(TODAY()),6,22-WEEKDAY(DATE(YEAR(TODAY()),6,1),2))</p><p>8=IF(MOD(MID(A2,2,1),2),REPLACE(A2,2,,8),REPLACE(A2,2,,3))</p><p><font color="#ff1111">第三题不正确，其他通过。</font></p><p><font color="#ff1111">注意：出生日期在当年的周数和今天在今年的周数相等，并不代表生日肯定在今天所在的这个星期内。</font></p><p><font color="#ff1111">举个例吧，1976-6-27在当年是第27周，今天2008-7-5也是27周。且生日天数27也大于今天天数5，满足条件。2008年27周是2008-6-29至2008-7-5，生日2008-6-27既不在本周内，也已经过去了。提醒在本周内生日，显示是不对的。&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; By:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; L.H.</font></p><p>&nbsp;</p>

[此贴子已经被jyh197994于2008-7-5 1:48:09编辑过]

amw9422585

我是没有点回复因为太长,发不出去,这次的题好难哦.看到这次的题就知道我现在有多差啊,要学的知识实在太多太多了

jyh197994

[em01]

CiCi-Hsu

<p>可以学习一下吗</p>

amw9422585

<p>谢谢班主任点评</p>

vbyou127

fggf