id: e1d0f95c1e694666941496df6b7eefad
parent_id: 
item_type: 1
item_id: 618d7ec9166147d5bbeb5f8387b261f2
item_updated_time: 1764345476142
title_diff: "[{\"diffs\":[[1,\"这7个Excel万能公式！赶紧收藏！\"]],\"start1\":0,\"start2\":0,\"length1\":0,\"length2\":18}]"
body_diff: "[{\"diffs\":[[1,\"<html>\\\r\\\n<head>\\\r\\\n  <title>这7个Excel万能公式！赶紧收藏！</title>\\\r\\\n  <basefont face=\\\"微软雅黑\\\" size=\\\"2\\\" />\\\r\\\n  <meta http-equiv=\\\"Content-Type\\\" content=\\\"text/html;charset=utf-8\\\" />\\\r\\\n  <meta name=\\\"exporter-version\\\" content=\\\"YXBJ Windows/608924 (zh-CN, DDL); Windows/10.0.0 (Win64); EDAMVersion=V2;\\\"/>\\\r\\\n  <style>\\\r\\\n\\tbody, td {\\\r\\\n\\t  font-family: 微软雅黑;\\\r\\\n\\t  font-size: 12pt;\\\r\\\n\\t}\\\r\\\n  </style>\\\r\\\n</head>\\\r\\\n<body>\\\r\\\n<a name=\\\"7898\\\"></a>\\\r\\\n<h1>这7个Excel万能公式！赶紧收藏！</h1>\\\r\\\n\\\r\\\n<div>\\\n<span>\\\n<div><div style=\\\"font-size: 18px; font-family: PingFangSC-Regular; letter-spacing: 1.2px; line-height: 30px; text-align: justify;\\\"><div style=\\\"visibility: visible;\\\"><p style=\\\"margin-right: 16px; margin-left: 16px; outline: 0px; max-width: 100%; font-family: -apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei UI&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; white-space: normal; background-color: rgb(255, 255, 255); box-sizing: border-box !important; word-wrap: break-word !important; overflow-wrap: break-word !important;\\\"><img src=\\\":/f7a8d78858794df2b7a5bfd0daa3d428\\\" type=\\\"image/gif\\\" data-filename=\\\"Image.gif\\\" alt=\\\"图片\\\" style=\\\"outline: 0px; font-size: 16px; letter-spacing: 0.544px; box-sizing: border-box !important; word-wrap: break-word !important; overflow-wrap: break-word !important; visibility: visible !important; width: 578px !important; height: auto !important;\\\"/></p><div style=\\\"margin-right: 16px; margin-left: 16px; outline: 0px; max-width: 100%; font-family: -apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei UI&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; white-space: normal; background-color: rgb(255, 255, 255); box-sizing: border-box !important; word-wrap: break-word !important;\\\"><span style=\\\"outline: 0px; max-width: 100%; color: rgb(89, 89, 89); box-sizing: border-box !important; word-wrap: break-word !important;\\\">来  源：Excel不加班/作  者：卢子</span></div><div><div><div style=\\\"box-sizing: border-box;padding-right: 16px;padding-left: 16px;\\\"><div><p style=\\\"text-align: center; vertical-align: inherit;\\\"><span style=\\\"\\\">今天，</span></p><p style=\\\"text-align: center; vertical-align: inherit;\\\"><span style=\\\"\\\">整理了一些超好用的公式，</span></p><p style=\\\"text-align: center; vertical-align: inherit;\\\"><span style=\\\"\\\">几乎都能用得上。</span></p><div><div style=\\\"text-align: center;\\\"><div style=\\\"box-sizing:border-box;width:3.6em;display: inline-block;\\\"><img src=\\\":/e69b4f07c80a4332831bfc0188fcb9e7\\\" type=\\\"image/gif\\\" data-filename=\\\"Image.gif\\\" alt=\\\"图片\\\" style=\\\"box-sizing: border-box; vertical-align: inherit; display: block; width: 3.6em !important; height: auto !important; visibility: visible !important;\\\"/></div></div></div><div><div style=\\\"text-align: left;margin: 10px auto;\\\"><div style=\\\"display: inline-block;\\\"><div style=\\\"background-color: rgb(255, 76, 0); padding: 6px 17px; border-top-left-radius: 20px; border-top-right-radius: 0px; border-bottom-right-radius: 20px; border-bottom-left-radius: 20px; box-sizing: border-box;\\\"><div style=\\\"color: rgb(255, 234, 211);\\\"><span style=\\\"color: #ffffff;\\\"><strong><span style=\\\"\\\">1、四舍五入，防止出现1毛钱的差异</span></strong></span></div></div></div><div style=\\\"box-sizing: border-box;width: 100%;height: 1px;background-color: rgb(255, 76, 0);margin-top: 5px;overflow: hidden;\\\"><br/></div></div></div><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"\\\">在核对金额的时候，经常会出现这种情况，明明两个金额看起来一样，但是公式显示结果却有问题，怎么回事呢？<br style=\\\"outline: 0px;max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;\\\"/></span></p><blockquote><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"color: rgb(127, 127, 127);\\\">=IF(D2=E2,&quot;正确&quot;,&quot;错误&quot;)</span></p></blockquote><p style=\\\"text-align: center; vertical-align: inherit;\\\"><img src=\\\":/1e39913ecf76468db751611d4f626ce9\\\" type=\\\"image/png\\\" data-filename=\\\"Image.png\\\" alt=\\\"图片\\\" style=\\\"box-sizing: border-box; vertical-align: inherit; border: 1px solid rgb(151, 152, 153); background-color: rgb(255, 255, 255); border-top-left-radius: 0px; border-top-right-radius: 0px; border-bottom-right-radius: 0px; border-bottom-left-radius: 0px; padding: 4px; width: 464px !important; height: auto !important; visibility: visible !important;\\\"/><br style=\\\"outline: 0px;max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;\\\"/></p><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"\\\">9.9设置单元格为整数就是10，但实际还是9.9，设置单元格并不能改变数字原来的大小。如果要改变大小，进行四舍五入，需要嵌套ROUND。0就是保留整数，如果是2就是保留小数点2位。</span></p><blockquote><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"color: rgb(127, 127, 127);\\\">=IF(ROUND(D2,0)=E2,&quot;正确&quot;,&quot;错误&quot;)</span></p></blockquote><p style=\\\"text-align: center; vertical-align: inherit;\\\"><img src=\\\":/3738be67712b416f883e37facc227275\\\" type=\\\"image/png\\\" data-filename=\\\"Image.png\\\" alt=\\\"图片\\\" style=\\\"box-sizing: border-box; vertical-align: inherit; border: 1px solid rgb(151, 152, 153); background-color: rgb(255, 255, 255); border-top-left-radius: 0px; border-top-right-radius: 0px; border-bottom-right-radius: 0px; border-bottom-left-radius: 0px; padding: 4px; width: 464px !important; height: 154.81034482758622px !important;\\\"/><br style=\\\"outline: 0px;max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;\\\"/></p><div><div style=\\\"text-align: left;margin: 10px auto;\\\"><div style=\\\"display: inline-block;\\\"><div style=\\\"background-color: rgb(255, 76, 0); padding: 6px 17px; border-top-left-radius: 20px; border-top-right-radius: 0px; border-bottom-right-radius: 20px; border-bottom-left-radius: 20px; box-sizing: border-box;\\\"><div style=\\\"color: rgb(255, 234, 211);\\\"><span style=\\\"color: #ffffff;\\\"><strong><span style=\\\"\\\">2、根据商品查找单价</span></strong></span></div></div></div><div style=\\\"box-sizing: border-box;width: 100%;height: 1px;background-color: rgb(255, 76, 0);margin-top: 5px;overflow: hidden;\\\"><br/></div></div></div><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"\\\">在很多公司，都有商品对应表，直接通过VLOOKUP进行查找，就不用再手工输入了。</span></p><blockquote><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"color: rgb(127, 127, 127);\\\">=VLOOKUP(A2,H:I,2,0)</span></p></blockquote><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"\\\">语法：<br style=\\\"outline: 0px;max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;\\\"/></span></p><blockquote><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"color: rgb(127, 127, 127);\\\">=VLOOKUP(查找值,要在哪个区域查找,返回区域第几列,0)</span></p></blockquote><div><div style=\\\"text-align: left;margin: 10px auto;\\\"><div style=\\\"display: inline-block;\\\"><div style=\\\"background-color: rgb(255, 76, 0); padding: 6px 17px; border-top-left-radius: 20px; border-top-right-radius: 0px; border-bottom-right-radius: 20px; border-bottom-left-radius: 20px; box-sizing: border-box;\\\"><div style=\\\"color: rgb(255, 234, 211);\\\"><span style=\\\"color: #ffffff;\\\"><strong><span style=\\\"\\\">3、统计总金额</span></strong></span></div></div></div><div style=\\\"box-sizing: border-box;width: 100%;height: 1px;background-color: rgb(255, 76, 0);margin-top: 5px;overflow: hidden;\\\"><br/></div></div></div><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"\\\">如果原来区域已经有金额这一列，那SUM就可以。<br style=\\\"outline: 0px;max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;\\\"/></span></p><blockquote><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"color: rgb(127, 127, 127);\\\">=SUM(D2:D5)</span></p></blockquote><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"\\\">如果原来区域没有金额这一列，要用SUMPRODUCT才行。SUMPRODUCT的用法非常多，这种用逗号隔开的就是最原始的，就是对两个区域的乘积再求和。</span></p><blockquote><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"color: rgb(127, 127, 127);\\\">=SUMPRODUCT(B2:B5,C2:C5)</span></p></blockquote><p style=\\\"text-align: center; vertical-align: inherit;\\\"><img src=\\\":/5a18554581dd4e3896d3c0f81a9cdbbe\\\" type=\\\"image/png\\\" data-filename=\\\"Image.png\\\" alt=\\\"图片\\\" style=\\\"box-sizing: border-box; vertical-align: inherit; border: 1px solid rgb(151, 152, 153); background-color: rgb(255, 255, 255); border-top-left-radius: 0px; border-top-right-radius: 0px; border-bottom-right-radius: 0px; border-bottom-left-radius: 0px; padding: 4px; width: 464px !important; height: 143.06896551724137px !important;\\\"/><br style=\\\"outline: 0px;max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;\\\"/></p><div><div style=\\\"text-align: left;margin: 10px auto;\\\"><div style=\\\"display: inline-block;\\\"><div style=\\\"background-color: rgb(255, 76, 0); padding: 6px 17px; border-top-left-radius: 20px; border-top-right-radius: 0px; border-bottom-right-radius: 20px; border-bottom-left-radius: 20px; box-sizing: border-box;\\\"><div style=\\\"color: rgb(255, 234, 211);\\\"><span style=\\\"color: #ffffff;\\\"><strong><span style=\\\"\\\">4、统计每个商品的总金额</span></strong></span></div></div></div><div style=\\\"box-sizing: border-box;width: 100%;height: 1px;background-color: rgb(255, 76, 0);margin-top: 5px;overflow: hidden;\\\"><br/></div></div></div><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"\\\">商品都是不断的销售，因此就会产生很多条记录，需要进行汇总，SUMIF就派上用场。</span></p><blockquote><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"color: rgb(127, 127, 127);\\\">=SUMIF(B:B,G2,E:E)</span></p></blockquote><p style=\\\"text-align: center; vertical-align: inherit;\\\"><img src=\\\":/3f34f49e9a6c4d89973221d27eeea316\\\" type=\\\"image/png\\\" data-filename=\\\"Image.png\\\" alt=\\\"图片\\\" style=\\\"box-sizing: border-box; vertical-align: inherit; border: 1px solid rgb(151, 152, 153); background-color: rgb(255, 255, 255); border-top-left-radius: 0px; border-top-right-radius: 0px; border-bottom-right-radius: 0px; border-bottom-left-radius: 0px; padding: 4px; width: 464px !important; height: 188.23703703703706px !important;\\\"/><br style=\\\"outline: 0px;max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;\\\"/></p><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"\\\">语法：<br style=\\\"outline: 0px;max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;\\\"/></span></p><blockquote><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"color: rgb(127, 127, 127);\\\">=SUMIF(条件区域,条件,求和区域)</span></p></blockquote><div></div><div><div style=\\\"text-align: left;margin: 10px auto;\\\"><div style=\\\"display: inline-block;\\\"><div style=\\\"background-color: rgb(255, 76, 0); padding: 6px 17px; border-top-left-radius: 20px; border-top-right-radius: 0px; border-bottom-right-radius: 20px; border-bottom-left-radius: 20px; box-sizing: border-box;\\\"><div style=\\\"color: rgb(255, 234, 211);\\\"><span style=\\\"color: #ffffff;\\\"><strong><span style=\\\"\\\">5、对每个商品的总金额进行排名</span></strong></span></div></div></div><div style=\\\"box-sizing: border-box;width: 100%;height: 1px;background-color: rgb(255, 76, 0);margin-top: 5px;overflow: hidden;\\\"><br/></div></div></div><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"\\\">当商品比较多的时候，就需要进行排名，也就是RANK。这里需要注意一下，区域要绝对引用，昨天刷某音的时候，看到某个点赞1000多的视频，居然没锁定，尴尬。</span></p><blockquote><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"color: rgb(127, 127, 127);\\\">=RANK(H2,$H$2:$H$5)</span></p></blockquote><p style=\\\"text-align: center; vertical-align: inherit;\\\"><img src=\\\":/0e0672d50f87474691ee554d00643bdd\\\" type=\\\"image/png\\\" data-filename=\\\"Image.png\\\" alt=\\\"图片\\\" style=\\\"box-sizing: border-box; vertical-align: inherit; border: 1px solid rgb(151, 152, 153); background-color: rgb(255, 255, 255); border-top-left-radius: 0px; border-top-right-radius: 0px; border-bottom-right-radius: 0px; border-bottom-left-radius: 0px; padding: 4px; width: 464px !important; height: 174.3793103448276px !important;\\\"/><br style=\\\"outline: 0px;max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;\\\"/></p><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"\\\">公式在下拉的时候，如果是引用一整列，允许不锁定区域；如果引用部分区域，必须锁定，否则下拉的时候，区域就错位。<br style=\\\"outline: 0px;max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;\\\"/></span></p><p style=\\\"text-align: center; vertical-align: inherit;\\\"><img src=\\\":/11146619ae194cefa34b487b686c5713\\\" type=\\\"image/png\\\" data-filename=\\\"Image.png\\\" alt=\\\"图片\\\" style=\\\"box-sizing: border-box; vertical-align: inherit; border: 1px solid rgb(151, 152, 153); background-color: rgb(255, 255, 255); border-top-left-radius: 0px; border-top-right-radius: 0px; border-bottom-right-radius: 0px; border-bottom-left-radius: 0px; padding: 4px; width: 464px !important; height: 160.68103448275863px !important;\\\"/></p><div><div style=\\\"text-align: left;margin: 10px auto;\\\"><div style=\\\"display: inline-block;\\\"><div style=\\\"background-color: rgb(255, 76, 0); padding: 6px 17px; border-top-left-radius: 20px; border-top-right-radius: 0px; border-bottom-right-radius: 20px; border-bottom-left-radius: 20px; box-sizing: border-box;\\\"><div style=\\\"color: rgb(255, 234, 211);\\\"><span style=\\\"color: #ffffff;\\\"><strong><span style=\\\"\\\">6、统计每个月的总金额</span></strong></span></div></div></div><div style=\\\"box-sizing: border-box;width: 100%;height: 1px;background-color: rgb(255, 76, 0);margin-top: 5px;overflow: hidden;\\\"><br/></div></div></div><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"\\\">SUMIF的条件区域不支持嵌套MONTH，只好借助SUMPRODUCT。</span></p><blockquote><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"color: rgb(127, 127, 127);\\\">=SUMPRODUCT((MONTH($A$2:$A$9)=G2)*$E$2:$E$9)</span></p></blockquote><p style=\\\"text-align: center; vertical-align: inherit;\\\"><img src=\\\":/5b328f3801464d708f838d07a0f64c90\\\" type=\\\"image/png\\\" data-filename=\\\"Image.png\\\" alt=\\\"图片\\\" style=\\\"box-sizing: border-box; vertical-align: inherit; border: 1px solid rgb(151, 152, 153); background-color: rgb(255, 255, 255); border-top-left-radius: 0px; border-top-right-radius: 0px; border-bottom-right-radius: 0px; border-bottom-left-radius: 0px; padding: 4px; width: 464px !important; height: 175.35775862068965px !important;\\\"/><br style=\\\"outline: 0px;max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;\\\"/></p><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"\\\">语法说明：<br style=\\\"outline: 0px;max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;\\\"/></span></p><blockquote><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"color: rgb(127, 127, 127);\\\">=SUMPRODUCT((条件区域=条件)*求和区域)</span></p></blockquote><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"\\\">这里有一个注意点，就是日期有的时候是跨年的，就不能直接用MONTH，还需要判断年份。</span></p><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"\\\">TEXT($A$2:$A$9,&quot;emm&quot;)就是将日期转换成年月的形式。</span></p><blockquote><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"color: rgb(127, 127, 127);\\\">=SUMPRODUCT((TEXT($A$2:$A$9,&quot;emm&quot;)=&quot;2021&quot;&amp;G2)*$E$2:$E$9)</span></p></blockquote><p style=\\\"text-align: center; vertical-align: inherit;\\\"><img src=\\\":/64774f1a9c55435686062eac7ac16d5b\\\" type=\\\"image/png\\\" data-filename=\\\"Image.png\\\" alt=\\\"图片\\\" style=\\\"box-sizing: border-box; vertical-align: inherit; border: 1px solid rgb(151, 152, 153); background-color: rgb(255, 255, 255); border-top-left-radius: 0px; border-top-right-radius: 0px; border-bottom-right-radius: 0px; border-bottom-left-radius: 0px; padding: 4px; width: 464px !important; height: 168.50862068965517px !important;\\\"/><br/></p><div><div style=\\\"text-align: left;margin: 10px auto;\\\"><div style=\\\"display: inline-block;\\\"><div style=\\\"background-color: rgb(255, 76, 0); padding: 6px 17px; border-top-left-radius: 20px; border-top-right-radius: 0px; border-bottom-right-radius: 20px; border-bottom-left-radius: 20px; box-sizing: border-box;\\\"><div style=\\\"color: rgb(255, 234, 211);\\\"><span style=\\\"color: #ffffff;\\\"><strong><span style=\\\"\\\">7、计算工龄、年龄</span></strong></span></div></div></div><div style=\\\"box-sizing: border-box;width: 100%;height: 1px;background-color: rgb(255, 76, 0);margin-top: 5px;overflow: hidden;\\\"><br/></div></div></div><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"\\\">截止到今天，都按年算。<br style=\\\"outline: 0px;max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;\\\"/></span></p><p style=\\\"text-align: center; vertical-align: inherit;\\\"><img src=\\\":/f104b650c40a4b228d94d58acae90f5d\\\" type=\\\"image/png\\\" data-filename=\\\"Image.png\\\" alt=\\\"图片\\\" style=\\\"box-sizing: border-box; vertical-align: inherit; border: 1px solid rgb(151, 152, 153); background-color: rgb(255, 255, 255); border-top-left-radius: 0px; border-top-right-radius: 0px; border-bottom-right-radius: 0px; border-bottom-left-radius: 0px; padding: 4px; width: 464px !important; height: 152.85344827586206px !important;\\\"/></p><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"\\\">工龄：<br style=\\\"outline: 0px;max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;\\\"/></span></p><blockquote><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"color: rgb(127, 127, 127);\\\">=DATEDIF(B2,TODAY(),&quot;y&quot;)</span></p></blockquote><p style=\\\"text-align: center; vertical-align: inherit;\\\"><img src=\\\":/036802c48a7f4b7e869b29a834903cc0\\\" type=\\\"image/png\\\" data-filename=\\\"Image.png\\\" alt=\\\"图片\\\" style=\\\"box-sizing: border-box; vertical-align: inherit; border: 1px solid rgb(151, 152, 153); background-color: rgb(255, 255, 255); border-top-left-radius: 0px; border-top-right-radius: 0px; border-bottom-right-radius: 0px; border-bottom-left-radius: 0px; padding: 4px; width: 464px !important; height: 175.35775862068965px !important;\\\"/><br style=\\\"outline: 0px;max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;\\\"/></p><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"\\\">DATEDIF函数语法：</span></p><blockquote><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"color: rgb(127, 127, 127);\\\">=DATEDIF(开始日期,结束日期,间隔)</span></p></blockquote><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"\\\">间隔为y代表年，m代表月，d代表日。</span></p><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"\\\">年龄：<br style=\\\"outline: 0px;max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;\\\"/></span></p><blockquote><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"color: rgb(127, 127, 127);\\\">=DATEDIF(TEXT(MID(A2,7,8),&quot;0-00-00&quot;),TODAY(),&quot;y&quot;)</span></p></blockquote><p style=\\\"text-align: center; vertical-align: inherit;\\\"><img src=\\\":/bc78ed7d5e3d4bdb9c6286abb042525b\\\" type=\\\"image/png\\\" data-filename=\\\"Image.png\\\" alt=\\\"图片\\\" style=\\\"box-sizing: border-box; vertical-align: inherit; border: 1px solid rgb(151, 152, 153); background-color: rgb(255, 255, 255); border-top-left-radius: 0px; border-top-right-radius: 0px; border-bottom-right-radius: 0px; border-bottom-left-radius: 0px; padding: 4px; width: 464px !important; height: 138.17672413793105px !important;\\\"/><br style=\\\"outline: 0px;max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;\\\"/></p><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"\\\">从第身份证第7位连续提取8位就是出生日期，再用TEXT转换成日期。<br style=\\\"outline: 0px;max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;\\\"/></span></p><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"\\\">如果不是按今天的日期，而是按今年最后一天，TODAY可以换成&quot;2021-12-31&quot;或者DATE(2021,12,31)。</span></p><p style=\\\"text-align: justify; vertical-align: inherit;\\\"><span style=\\\"\\\">以上，都是最最常用的公式，都必须要会的。</span></p></div><div><div style=\\\"margin: 10px auto;text-align: center;\\\"><div style=\\\"display: flex;justify-content: center;align-items: center;flex-direction: column;\\\"><div style=\\\"box-sizing:border-box;width: 32px;\\\"><img src=\\\":/200470aa85984ceeac006e98a4a0b709\\\" type=\\\"image/gif\\\" data-filename=\\\"Image.gif\\\" alt=\\\"图片\\\" style=\\\"box-sizing: border-box; vertical-align: inherit; display: block; width: 32px !important; height: 28px !important;\\\"/></div><div style=\\\"padding: 2px 0em; color: rgb(52, 110, 183); box-sizing: border-box;\\\"><strong>END</strong></div></div></div></div><div><div style=\\\"outline: 0px; max-width: 100%; font-family: -apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei UI&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; white-space: normal; box-sizing: border-box !important; word-wrap: break-word !important;\\\"><div style=\\\"outline: 0px;max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;\\\"><div style=\\\"outline: 0px;max-width: 100%;display: flex;justify-content: center;align-items: center;width: 677px;box-sizing: border-box !important;word-wrap: break-word !important;\\\"><div style=\\\"outline: 0px; max-width: 100%; border-top-left-radius: 0px; border-top-right-radius: 16px; border-bottom-right-radius: 0px; border-bottom-left-radius: 16px; border: 1px solid rgb(242, 162, 30); box-sizing: border-box !important; word-wrap: break-word !important;\\\"><div style=\\\"outline: 0px; max-width: 100%; transform: translate(-4px, -4px); background-color: rgb(242, 162, 30); border-top-left-radius: 0px; border-top-right-radius: 16px; border-bottom-right-radius: 0px; border-bottom-left-radius: 16px; box-sizing: border-box !important; word-wrap: break-word !important;\\\"><div style=\\\"outline: 0px;max-width: 100%;display: flex;justify-content: center;align-items: center;width: 198.359px;box-sizing: border-box !important;word-wrap: break-word !important;\\\"><div style=\\\"margin-left: 8px;outline: 0px;max-width: 100%;width: 14px;height: 7px;box-sizing: border-box !important;word-wrap: break-word !important;\\\"><img src=\\\":/5e790ecf6b2d44c19e0a044bce2cf1ee\\\" type=\\\"image/png\\\" data-filename=\\\"Image.png\\\" alt=\\\"图片\\\" style=\\\"outline: 0px; display: block; box-sizing: border-box !important; word-wrap: break-word !important; visibility: visible !important; width: 14px !important; height: 7px !important;\\\"/></div><div style=\\\"padding-right: 3px;padding-left: 3px;outline: 0px;max-width: 100%;height: 40px;text-align: center;box-sizing: border-box !important;word-wrap: break-word !important;\\\"><p style=\\\"outline: 0px; max-width: 100%; font-family: PingFangSC-Semibold, &quot;PingFang SC&quot;; font-weight: bold; color: rgb(255, 255, 255); box-sizing: border-box !important; word-wrap: break-word !important;\\\"><span style=\\\"outline: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;\\\">爱数据福利大放送</span></p></div><div style=\\\"margin-right: 8px;outline: 0px;max-width: 100%;width: 14px;height: 7px;transform: rotate(180deg);box-sizing: border-box !important;word-wrap: break-word !important;\\\"><img src=\\\":/b7d2c4d4579e462d9bf3d46ddc712828\\\" type=\\\"image/png\\\" data-filename=\\\"Image.png\\\" alt=\\\"图片\\\" style=\\\"outline: 0px; display: block; box-sizing: border-box !important; word-wrap: break-word !important; visibility: visible !important; width: 14px !important; height: 7px !important;\\\"/></div></div></div></div></div></div><p style=\\\"margin-right: 16px; margin-left: 16px; outline: 0px; max-width: 100%; text-align: center; box-sizing: border-box !important; word-wrap: break-word !important;\\\"><span style=\\\"outline: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;\\\">扫描/识别下方二维码后</span><br style=\\\"outline: 0px;max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;\\\"/></p><p style=\\\"margin-right: 16px; margin-left: 16px; outline: 0px; max-width: 100%; text-align: center; box-sizing: border-box !important; word-wrap: break-word !important;\\\"><span style=\\\"outline: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;\\\">回复</span><strong style=\\\"outline: 0px;max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;\\\"><span style=\\\"outline: 0px; max-width: 100%; color: rgb(0, 128, 255); box-sizing: border-box !important; word-wrap: break-word !important;\\\">【1202】</span></strong></p><p style=\\\"margin-right: 16px; margin-left: 16px; outline: 0px; max-width: 100%; text-align: center; box-sizing: border-box !important; word-wrap: break-word !important;\\\"><span style=\\\"outline: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;\\\">即可领取</span><span style=\\\"outline: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;\\\"><strong style=\\\"outline: 0px;max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;\\\"><span style=\\\"outline: 0px;max-width: 100%;color: rgb(0, 128, 255);box-sizing: border-box !important;word-wrap: break-word !important;\\\"><strong style=\\\"outline: 0px;max-width: 100%;letter-spacing: 0.544px;background-color: rgb(255, 255, 255);box-sizing: border-box !important;word-wrap: break-word !important;\\\"><span style=\\\"outline: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;\\\">《230份Excel图表模板》</span></strong></span></strong></span></p><div style=\\\"outline: 0px;max-width: 100%;box-sizing: border-box !important;word-wrap: break-word !important;\\\"><div style=\\\"margin: 10px auto;outline: 0px;max-width: 100%;width: 38px;box-sizing: border-box !important;word-wrap: break-word !important;\\\"><img src=\\\":/e915bce1bd7d4de5b1df8973d7359527\\\" type=\\\"image/gif\\\" data-filename=\\\"Image.gif\\\" alt=\\\"图片\\\" style=\\\"outline: 0px; box-sizing: border-box; display: block; word-wrap: break-word !important; visibility: visible !important; width: 38px !important; height: 38px !important;\\\"/></div></div></div><div style=\\\"outline: 0px; max-width: 100%; font-family: -apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei UI&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; white-space: normal; box-sizing: border-box !important; word-wrap: break-word !important;\\\"><p style=\\\"text-align: center;\\\"><img src=\\\":/153e282034164fdd8b13e38a24a314aa\\\" type=\\\"image/jpeg\\\" data-filename=\\\"Image.jpg\\\" alt=\\\"图片\\\" style=\\\"width: 215px !important; height: 215px !important;\\\"/></p></div><div style=\\\"margin-right: 16px; margin-left: 16px; outline: 0px; max-width: 100%; font-family: -apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei UI&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; white-space: normal; text-align: center; box-sizing: border-box !important; word-wrap: break-word !important;\\\"><img src=\\\":/dca27fa671054aa984be281462083580\\\" type=\\\"image/gif\\\" data-filename=\\\"Image.gif\\\" alt=\\\"图片\\\" style=\\\"outline: 0px; box-sizing: border-box !important; word-wrap: break-word !important; visibility: visible !important; width: 613px !important; height: 115.14814814814814px !important;\\\"/></div></div></div></div></div></div></div></div>\\\n</span>\\\n</div></body></html>\\u0000\"]],\"start1\":0,\"start2\":0,\"length1\":0,\"length2\":26852}]"
metadata_diff: {"new":{"id":"618d7ec9166147d5bbeb5f8387b261f2","parent_id":"061de1401cfc4cfaadf6e74e015970e9","latitude":"0.00000000","longitude":"0.00000000","altitude":"0.0000","author":"","source_url":"","is_todo":0,"todo_due":0,"todo_completed":0,"source":"joplin-desktop","source_application":"net.cozic.joplin-desktop","application_data":"","order":1764345893618,"markup_language":2,"is_shared":0,"share_id":"","conflict_original_id":"","master_key_id":"","user_data":"","deleted_time":0},"deleted":[]}
encryption_cipher_text: 
encryption_applied: 0
updated_time: 2025-11-28T16:20:27.959Z
created_time: 2025-11-28T16:20:27.959Z
type_: 13