excel2007 如何实现以下功能?

发布网友发布时间：2022-04-22 23:40

共3个回答

热心网友时间：2023-05-03 07:41

>1
=IF(DATEDIF($A2,TODAY(),"M")>=12,1,"")

>0.5
=IF(AND(DATEDIF($A2,TODAY(),"M")<12,DATEDIF($A2,TODAY(),"M")>=6),1,"")

<0.5
=IF(AND(DATEDIF($A2,TODAY(),"M")<6,DATEDIF($A2,TODAY(),"M")>=3),1,"")

<0.3
=IF(DATEDIF($A2,TODAY(),"M")<3,1,"")

热心网友时间：2023-05-03 07:41

A1填日期，=IF(TODAY()-A1>365,1,"")，后面的你要多少天就把365改成相应天数就成

热心网友时间：2023-05-03 07:42

>1=if(datedif(a2,today,"m")>=12,1,"")
>0.5=if(datedif(a2,today,"m")>=6,1,"")
>0.3=if(datedif(a2,today,"m")>=3,1,"")
<0.3=if(datedif(a2,today,"m<3,1,"")

声明：本网页内容为用户发布，旨在传播知识，不代表本网认同其观点，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。E-MAIL:11247931@qq.com