一些好用的 MSO Excel 函数: Revision history

Jump to navigation Jump to search

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

29 September 2025

  • curprev 09:5309:53, 29 September 2025‎ Mwroot talk contribs‎ 353 bytes +353‎ Created page with "本文介绍一些好用的 MSO excel 函数。 日期注意用英引号扩起来。 ; 计算两个日期之间差了几年 : =YEARFRAC("2018/9/30","2024/7/1",1) ; 对几年取整，舍弃小数部分 : =TRUNC(sth) ; 往后推算 5 年是哪个日期 : =EDATE("2018/9/30",5*12) ; 保留两位小数点 : =round(a1, 2) Category:MicroSoft Office"
Retrieved from "https://qingliezhiquan.com/blog/一些好用的_MSO_Excel_函数"