=YEAR(TODAY())-1*((LEN(G11)=15)*19&MID(G11,7,((LEN(G11)=18)*2+2)))
来源:百度知道 编辑:UC知道 时间:2024/05/12 12:36:07
这是什么意思,
这是计算机语言,应该是关于日期设定关联的,我也不太懂.
EXCEL语公式,从身份证号求出年龄。在G11输入身份证号,15位与18位的均可,就可以算出年龄了.
=if(a14<>"",min(500,(year(today())-year(员工基本情况!F14))*30),"")
=YEAR(TODAY())-1*((LEN(G11)=15)*19&MID(G11,7,((LEN(G11)=18)*2+2)))
TA devices that are shipping today (mid-year 2003) generally
SATA devices that are shipping today (mid-year 2003) generally
I sent you 100 dollars today ,the rest___in a year
=WEEKDAY(TODAY()-1,2)
I____ (finish) my end-of-year exam and get my report card today.其中finish的用现在时还是过去时?
判断闰年的条件:为什么是(year%4==0&year%100!=0)||(year%400==0) 而不是year%4==0?
year-to-year
Today 是什么意思?