只需尝试这个公式:
=COUNTIFS($A$2:$A$9,"<="&$A2,$A$2:$A$9,">"&TODAY())=1
=
即可:=COUNTIFS($A$2:$A$9,"<="&$A2,$A$2:$A$9,">="&TODAY())=1
请确保不要错过任何一个$
符号(也不要使用太多);)
或者,您也可以使用简短的公式(对于更大的表格可能会较慢):
=$A2=MIN(IF($A$2:$A$9>TODAY(),$A$2:$A$9))
$A$2:$A$9>=TODAY()
将包括当天日期。