<p>老师您好:我的作业是同学帮忙完成的,我听课还听得懂的,就是不会使用工具,那些技巧要是会用了,我想我能自已做出一部分的,我希望我能通过听课后达到我的梦想:自已能进入研究那不会的东东,一定是非常快乐的!谢谢老师的讲课和同学们的帮助!1、=EDATE(A2,(DATEDIF(A2,TODAY(),"Y")+1)*12)-TODAY()</p><p>2、=IF(AND(MONTH(A2)=MONTH(TODAY()),DAY(A2)>=DAY(TODAY())),"生日","")</p><p>3、=IF(AND(WEEKNUM(A2)=WEEKNUM(TODAY()),DAY(A2)>=DAY(TODAY())),"生日","")</p><p>4、=(B3-A3)*24*60</p><p>5、="NO."&REPT("0",10-LEN(A2))&A2</p><p>6、=--TEXT(A2,"yyyy-m-d")</p><p>=--TEXT(A2,"h:m")</p><p>7、=DATE(YEAR(TODAY()),6,22)-WEEKDAY(DATE(YEAR(TODAY()),6,22),2)</p><p>8、=IF(ISEVEN(MID(A2,2,1)),REPLACE(A2,2,0,"3"),REPLACE(A2,2,0,"8"))</p> |