如何在诸多日期中,批量提取超过今天日期的。函数 条件选择均可。
C2è¾å ¥
=TEXT(INDEX(A:A,SMALL(IF($A$2:$A$100>TODAY(),ROW($2:$100),200),ROW(A1)))&"","e/m/d")
æ°ç»å ¬å¼ï¼å æä½CTRL+SHIFT,æåå车ï¼ä½¿å¾ç¼è¾æ å ¬å¼ä¸¤ç«¯åºç°è±æ¬å·{ }
å ¬å¼ä¸æå°æ æ°æ®
=IF(TODAY()<A2,TEXT(A2,"yyyy/m/d"),"")
条件格式也行:
B1公式:=IF(A1>TODAY(),A1,"")