excel-day10

条件格式

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

=DATEDIF(DATE(YEAR(TODAY()),1,1),DATE(YEAR(TODAY()),12,31),"d")-DATEDIF(C2,TODAY()-1,"yd")<=15

posted @ 2019-08-15 22:23  进击的小laufen  阅读(117)  评论(0)    收藏  举报