函入班第5讲7组上交作业帖

dtl314159

学习

七组：心情

游客，如果您要查看本帖隐藏内容请回复

dengrong

<p>交作业：</p><p>1、=MIN(--TEXT(DATE(YEAR(NOW())+{1,0},MONTH(A2),DAY(A2))-TODAY(),"0;!366"))</p><p>2、=TEXT(TEXT(A2,"mdd")-TEXT(NOW(),"mdd"),"[&gt;30]_ ;;生日")</p><p>3、=TEXT(TEXT(A2,"mdd")-TEXT(NOW(),"mdd"),"[&gt;"&amp;7-WEEKDAY(NOW(),2)&amp;"]_ ;;生日")</p><p>4、=TEXT(B3-A3,"[M]")</p><p>5、=TEXT(A2,"!NO!.0000000000")</p><p>6、=TEXT(A2,"e-m-d")</p><p>7、="6-22"-WEEKDAY("6-1",2)</p><p>8、=TEXT(LEFT(A2)&amp;MOD(LEFT(A2,2),2)*5+3,"0!E8")+MID(A2,2,9)</p><p>这个作业我做得特别吃力，还是经同学讲解才能交上的。</p>

风1234

<p>学习！</p>

ANNAf85

作业不会做

qq361917285

<p>交作业了.</p><p>

游客，如果您要查看本帖隐藏内容请回复

</p>

fzylx

看看<strong><font face="Verdana" color="#61b713">lxgexcel第八题是怎么做的</font></strong>

vbyou127

5885858555