使用道具 举报
superslow 发表于 2017-12-7 17:37 =IF(TEXT(TODAY(),"yyyymm")=TEXT(H30,"yyyymm"),"是","否")
高 发表于 2017-12-7 20:35 =IF(AND(MONTH(TODAY())-MONTH(H30)=1,YEAR(TODAY())=YEAR(H30)),"是","否") 或者=IF(TEXT(TODAY()-DAY(TO ...
ripplehe 发表于 2017-12-15 16:19 您好!按照您的方法,遇到个问题! H30如果都是2017年的话是可行的,但是遇到跨年就不行了。 我把系统 ...
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-4-26 05:50 , Processed in 0.300620 second(s), 8 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.