|
[练习题]
1、=DATEDIF(TODAY(),DATE(IF(DATE(2008,MONTH(A2),DAY(A2))>=DATE(2008,6,26),2008,2009),MONTH(A2),DAY(A2)),"d")+2</p><p>2、=IF(MONTH(A2)=6,"生日","") 3、=IF(AND(MONTH(A2)=MONTH(TODAY()),DAY(A2)>=DAY(TODAY())),"生日","")</p><p>4、=(B3-A3)*24*60 5、="NO."&REPT("0",10-LEN(A2))&A2; 6、=TEXT(A2,"yyyy-m-d");=TEXT(A2,"h:m") </p><p>7、=DATE(YEAR(TODAY()),6,22)-WEEKDAY(DATE(YEAR(TODAY()),6,22),2)</p><p>8、=IF(MOD(MID(A2,2,1),2)=0,REPLACE(A2,2,0,"3"),REPLACE(A2,2,0,"8"))</p>[/hide] |
|