第1个回答 2012-04-21
b6
=if(and(b2>date(2012,1,1),b2<=today()-date(today())),j6,"")
如果是大于1月(从2月1日开始),改为:
=if(and(b2>date(2012,2,0),b2<=today()-date(today())),j6,"")本回答被网友采纳
第2个回答 2012-04-13
=IF(AND(TEXT(B2,"emm")>"201201",TEXT(B2,"emm")<TEXT(TODAY(),"emm")),J6,"")