我是Google表格的新手,我想做这样的事情:
IF ( (current time is within 8am - 2pm) AND (day is NOT (sunday OR saturday) )
THEN => cell value = "OPEN"
ELSE => cell value = "CLOSED"
=IF(AND(HOUR(NOW())>=8, HOUR(NOW())<=14, WEEKDAY(NOW(),2)<6), "OPEN", "CLOSED")
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句