=today() 就可以，格式是右键单元格，点格式，改为日期。=YEAR(MONTH(TODAY()))的意思是，从2012-11中提取11,但11不是正常的时间，系统会计算成1900年1月，相当于最后成了Year(1900-1)，正常下显示为1900,但格式如果改为时期，则会显示为1905年3月
在excel中,在a1单元格是身份证号,在b1单元格输入YEAR(TODAY()-MID算出来显示1905/6/20,要怎么算出年龄? 2020.07.09浏览11次其他分享举报1个回答 jinzhan88 2020.07.10 满意答案 如果按自然年算,那就year(today())-mid(a1,7,4) 之后将单元格格式设置为“常规” 追问: 我都把a1 ,b1单元格格式设置为“常...
为什么year(today()-f3)-1900结果是1905-6呢(f3=2001-9) run0 见E勇为 7 因为你看起来的日期,电脑是当成一个数来算的。再显示的时候再显示成日期。 登录百度帐号 扫二维码下载贴吧客户端 下载贴吧APP看高清直播、视频! 贴吧页面意见反馈 违规贴吧举报反馈通道 贴吧违规信息处理公示7...
3. It is hot and___today. What about going for a swim? 4. Planting more trees will make the environment much___and better. 5. Don’t always stay up late. An unhealthy lifestyle can___illnesses. 6. Great changes___in Lianyungang since I moved here. 7. If you have difficulty in...
a今天是周末没工作吧 Today is the weekend work [translate] a你永远是我的老婆...好爱你 You forever are my wife….Good loves you [translate] a如今课堂学习是学生获取知识的主要途径。然而,课外所学知识同意重要。只有把两者结合起来才是最佳方法。 Now the classroom study is the student knowledge acqu...
a下雨了,我们今天去公园吗? Rains, we go to the park today?[translate] ayou are right, we do not need to care about the grammar ... just say what you want to say 您正确,我们不需要对语法关心… 言什么您想要说[translate] aOn top of the 在顶部[translate] ...
From a u-CT scan and an X-ray, researchers identified a fibrous dysplastic neoplasm -- today, the most common form of benign bone tumor in humans -- located on a Neandertal left rib fragment that measured 30 mm (4 ½ inches) long. Judging by the size of the rib fragment, at the...
Today,people in more than forty(68)(country) celebrate the day.They give their mothers carnations (康乃馨)and other presents..In the language (69) flowers,carnations mean happiness,(70) (sweet) and love. 答案 61.night 考查名词,根据day and,推出是短语day and night白天黑夜,句...
No Day But Today: The Story of 'Rent'[演员(饰 Herself)] 导演 Jeffrey Schwarz 主演 Billy AronsonMartha Banta迈克尔·巴纳森Tom BuderwitzJonathan Burkhart 2005 吉屋出租[演员] 导演 克里斯·哥伦布 主演 安东尼·拉普Adam Pascal罗莎里奥·道森Jesse L. MartinWilson Jermaine Heredia 剧情 纽约东部一个...