Three useful date functions in mso excel

From 清冽之泉
Revision as of 16:38, 20 November 2024 by Mwroot (talk | contribs) (Created page with "; 计算两个日期之间差了几年 : =YEARFRAC("2018/9/30","2024/7/1",1) ; 对几年取整，舍弃小数部分 : =TRUNC(sth) ; 往后推算 5 年是哪个日期 : =EDATE("2018/9/30",5*12) 日期注意用英引号扩起来。")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
计算两个日期之间差了几年
=YEARFRAC("2018/9/30","2024/7/1",1)
对几年取整，舍弃小数部分
=TRUNC(sth)
往后推算 5 年是哪个日期
=EDATE("2018/9/30",5*12)

日期注意用英引号扩起来。

Retrieved from "https://qingliezhiquan.com/mediawiki/index.php?title=Three_useful_date_functions_in_mso_excel&oldid=3688"