工作期间表 (11174)

H3 右拉 下 拉=IF((DATE(YEAR(NOW()),LOOKUP(99,$H$1:H$1),H$2)>=$E3)*(DATE(YEAR(NOW()),LOOKUP(99,$H$1:H$1),H$2)<=$F3),"●","")

另解=IF(MEDIAN(DATE(YEAR(NOW()),LOOKUP(99,$H$1:H$1),H$2),$E3:$F3)=DATE(YEAR(NOW()),LOOKUP(99,$H$1:H$1),H$2),"●","")