|
<p><font color="#f70909">学习了!</font></p><p><font color="#f70909">1.条件格式 =OR(DATEDIF(--TEXT(MID($D9,7,6+(LEN($D9)=18)*2),"#-00-00"),NOW(),"y")=LARGE(DATEDIF(--TEXT(MID($D$9:$D$28,7,6+(LEN($D$9:$D$28)=18)*2),"#-00-00"),NOW(),"y"),COLUMN($A$1:$C$1)))<br/>2.=SUM(--(ROUNDUP(MONTH(E9:E28)/3,0)=3)) 数组<br/>3.=SUM(--(WEEKDAY(--TEXT(MID(D9:D28,7,6+(LEN(D9:D28)=18)*2),"#-00-00"))=1)) 数组<br/>4.=DATEDIF(--TEXT(MID(D9,7,6+(LEN(D9)=18)*2),"#-00-00"),E9,"y")</font></p> |
|