|
作业
<p>1:=DATEDIF(TODAY(),IF(MONTH(A2)-MONTH(TODAY())<0,YEAR(TODAY())+1,YEAR(TODAY()))&"-"&MONTH(A2)&"-"&DAY(A2),"d")</p><p>2:=IF(MONTH(A2)=MONTH(TODAY()),YEAR(TODAY())&"-"&MONTH(A2)&"-"&DAY(A2),"")</p><p>3:不会</p><p>4:=DATEDIF(A3,B3,"d")*24*60-((HOUR(A3)-HOUR(B3))*60+(MINUTE(A3)-MINUTE(B3)))</p><p>5:单元格格式→自定义→"NO."0000000000</p><p>6:=YEAR(A2)&"-"&MONTH(A2)&"-"&DAY(A2)</p><p>=HOUR(A2)&":"&MINUTE(A2)</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)=1,REPLACE(A2,2,,8),REPLACE(A2,2,,3))</p> |
|