公式化,显示不同日期,cell的颜色
=E$6=TODAY()
=AND( E$6<TODAY(), OR(E$5="Mo",E$5="Tu",E$5="We",E$5="Th",E$5="Fr") )
= OR( EXACT("Sa",E$5), EXACT("Su",E$5) )
2023-12-18 23:36:58
=E$6=TODAY()
=AND( E$6<TODAY(), OR(E$5="Mo",E$5="Tu",E$5="We",E$5="Th",E$5="Fr") )
= OR( EXACT("Sa",E$5), EXACT("Su",E$5) )