设置多条件函数公式
阶段TR1TR2TR3TR4TR5TR6TR7公式列
各阶段所处的时间2012-7-252012-8-262012-9-272012-10-292012-11-302013-1-12013-2-2TR1
2012-8-12012-8-242012-9-252012-10-252012-11-252012-12-252013-1-25
2012-7-262012-8-252012-9-242012-10-242012-11-232012-12-232013-1-22
2012-7-252012-8-242012-9-232012-10-232012-11-222012-12-222013-1-21
2012-8-12012-8-242012-9-212012-10-192012-11-162012-12-142013-1-11
2012-7-252012-8-232012-9-222012-10-202012-11-182012-12-172013-1-15
2012-7-262012-8-262012-9-272012-10-292012-11-302013-1-12013-2-2
公式要求:根据当前时间(today)判断所处的阶段
注意:各阶段时间顺序如下:TR1阶段:today~2012-7-25
TR2阶段:2012-7-26~2012-8-26
TR2/TR4阶段以此类推