=IF(ABS(TEXT(TODAY(),"m")-LEFT(A5))>6,TEXT(CONCATENATE(TEXT(

来源：学生作业帮编辑：大师作文网作业帮分类：综合作业时间：2024/11/12 10:28:55

=IF(ABS(TEXT(TODAY(),"m")-LEFT(A5))>6,TEXT(CONCATENATE(TEXT(TODAY(),"yyyy")+1,"-",LEFT(A5),"
麻烦帮忙看看这个函数哪里有问题,得出来的结果不令人满意；不仅如此选择5月12日13日14日都是星期天.29日是礼拜一,这对不上号啊
=IF(ABS(TEXT(TODAY(),"m")-LEFT(A5))>6,TEXT(CONCATENATE(TEXT(TODAY(),"yyyy")+1,"-",LEFT(A5),"-",LEFT(B5)),"aaaa"),TEXT(CONCATENATE(TEXT(TODAY(),"yyyy"),"-",LEFT(A5),"-",LEFT(B5)),"aaaa"))
函数在此.

6,TEXT(CONCATENATE(TEXT(" />

不需要这么复杂吧?
=TEXT(DATE(YEAR(TODAY())+(DATE(YEAR(TODAY()),SUBSTITUTE(A5,"月",),SUBSTITUTE(B5,"日",))

="今天是:"&TEXT(TODAY(),"yyyy年m月d日")&"【"&TEXT(TODAY(),"[$-804]a text(today()-g4,"d") if (A.Text == "身份证" && (B.Text.Length != 15||B.Text.Length ! If text1.text"" then... TextBox1.Text = Mid(TextBox1.Text,1,Len(TextBox1.Text) - txtShow.Text = txtShow.Text.Substring(0,txtShow.Text.Length txtsrc.text=left(txtsrc.text,txtsrc.selstart)&mid(txtsrc.tex style=text-decoration: if (textBox1.Text == "0") textBox1.Text = ""; this.textBox1. If Text1.Text = "" Then s_id = "%" Else s_id = Text1.Text En pb 9语法错, if sle_user.text="zwh" and sle_password.text="123". pb 9语法错,if sle_user.text="zwh" and sle_password.text="123".如