|
交作业
<p>1、=EDATE(A2,(DATEDIF(A2,TODAY(),"Y")+1)*12)-TODAY()</p><p>2、=IF(AND(MONTH(A2)=MONTH(TODAY()),DAY(A2)>=DAY(TODAY())),"生日","")</p><p>3、=IF(AND(WEEKNUM(A2)=WEEKNUM(TODAY()),DAY(A2)>=DAY(TODAY())),"生日","")</p><p>4、=(B3-A3)*24*60</p><p>5、="NO."&REPT("0",10-LEN(A2))&A2</p><p>6、=--TEXT(A2,"yyyy-m-d")</p><p>=--TEXT(A2,"h:m")</p><p>7、=DATE(YEAR(TODAY()),6,22)-WEEKDAY(DATE(YEAR(TODAY()),6,22),2)</p><p>8、=IF(ISEVEN(MID(A2,2,1)),REPLACE(A2,2,0,"3"),REPLACE(A2,2,0,"8"))</p> |
|