<p>第1题:=IF(DATE(YEAR(TODAY()),MONTH(A2),DAY(A2))>TODAY(),DATE(YEAR(TODAY()),MONTH(A2),DAY(A2))-TODAY()+1,DATE(YEAR(TODAY())+1,MONTH(A2),DAY(A2))-TODAY()+1)</p><p>第2题:=IF(AND(MONTH(A2)=MONTH(TODAY()),DAY(A2)>DAY(TODAY())),"本月过生日","")</p><p>第3题:=IF(AND(MONTH(A2)=MONTH(TODAY()),IF(WEEKDAY(DATE(YEAR(TODAY()),MONTH(A2),DAY(A2)))>2,DATE(YEAR(TODAY()),MONTH(A2),DAY(A2))>=DATE(YEAR(TODAY()),MONTH(A2),DAY(A2))-WEEKDAY(DATE(YEAR(TODAY()),MONTH(A2),DAY(A2)))+1),DATE(YEAR(TODAY()),MONTH(A2),DAY(A2))<=DATE(YEAR(TODAY()),MONTH(A2),DAY(A2))-WEEKDAY(DATE(YEAR(TODAY()),MONTH(A2),DAY(A2)))+1+7),"本周过生日","")</p><p>第4题:=(B3-A3)*24*60</p><p>第5题:="NO."&TEXT(A2,"0000000000")</p><p>第6题:=MID(TEXT(A2,"yyyy-m-d h:mm"),1,FIND("/",SUBSTITUTE(TEXT(A2,"yyyy-m-d h:mm")," ","/")))</p><p> =MID(TEXT(A2,"yyyy-m-d h:mm"),FIND("/",SUBSTITUTE(TEXT(A2,"yyyy-m-d h:mm")," ","/")),LEN(TEXT(A2,"yyyy-m-d h:mm")))</p><p>第7题:=DATE(YEAR(TODAY()),6,IF(WEEKDAY(DATE(YEAR(TODAY()),6,1))=1,7*2+1,7-WEEKDAY(DATE(YEAR(TODAY()),6,1))+1+7*2))</p><p>第8题:=LEFT(A2)&IF(MOD(LEFT(A2,2),2),"8","3")&MID(A2,2,9)</p><p><font color="#ff1111">第1题:不正确,多出一天.</font></p><p><font color="#ff1111">第2题:通过.</font></p><p><font color="#ff1111">第3题:不正确. 过去的生日也会提示.你试下7-1号.</font></p><p><font color="#ff1111">第4,5,6题: 通过. 但第6题太复杂.没有必要.</font></p><p><font color="#ff1111">第7题:不正确. 你试试2009年或2010年就知道了.</font></p><p><font color="#ff1111">第8题:通过. by L.H.</font></p><p> </p>
[此贴子已经被jyh197994于2008-7-2 16:52:34编辑过] |