当前时间： 2026-06-06 08:08:27
分类：办公文件
评论(0)
Excel-50(时间日期函数)Excel的数据的主要类型分为三类：文本、数值、时间日期。时间日期是非常特殊的一块的内容。时间指“年月日”，日期指“时分秒”。以及由于工作而衍生出来的星期一，一年的第几周。
DAYS(结束日期，开始日期）的计算方式与datedif不同
还有一个计算日期差好用的函数：datedif(开始日期，结束日期，单位）单位有：年-“Y”,月-“M”,日-“D”。是完整精确计算的。如上，因结束日期为达到9月1号，相当于10.x年，默认向下取整。如果用粗略计算：year(2026/5/27)-year(2015/9/1)=11。粗略计算当于一个人的虚岁/名义年龄，精确计算相当于一个人的周岁/实岁。~~到这里啦
我的Excel-1,开始于2025的双11。今天第50篇了。
生活也许没有意义，但每天需要有个盼头，希望，念头。
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-06-06 11:49:34 HTTP/1.1 GET : https://www.yeyulingfeng.com/a/713548.html
- 运行时间 : 0.153345s [ 吞吐率：6.52req/s ] 内存消耗：4,872.73kb 文件加载：145
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=d9f003567a16899564c1a758a2053697
- CONNECT:[ UseTime:0.000457s ] mysql:host=127.0.0.1;port=3306;dbname=wenku;charset=utf8mb4
- SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.000867s ]
- SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.000305s ]
- SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.000640s ]
- SHOW FULL COLUMNS FROM `set` [ RunTime:0.001275s ]
- SELECT * FROM `set` [ RunTime:0.000604s ]
- SHOW FULL COLUMNS FROM `article` [ RunTime:0.001532s ]
- SELECT * FROM `article` WHERE `id` = 713548 LIMIT 1 [ RunTime:0.006387s ]
- UPDATE `article` SET `lasttime` = 1780717774 WHERE `id` = 713548 [ RunTime:0.005817s ]
- SELECT * FROM `fenlei` WHERE `id` = 64 LIMIT 1 [ RunTime:0.000627s ]
- SELECT * FROM `article` WHERE `id` < 713548 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001038s ]
- SELECT * FROM `article` WHERE `id` > 713548 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.002841s ]
- SELECT * FROM `article` WHERE `id` < 713548 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.003715s ]
- SELECT * FROM `article` WHERE `id` < 713548 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.019932s ]
- SELECT * FROM `article` WHERE `id` < 713548 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.006119s ]
0.157389s
夜雨聆风
