Difference between revisions of "三个好用的计算日期的 MSO Excel 函数"
Jump to navigation
Jump to search
← Older edit
三个好用的计算日期的 MSO Excel 函数
(view source)
Revision as of 11:43, 18 June 2024
38 bytes added
,
18 June
no edit summary
Revision as of 11:12, 18 June 2024
(
view source
)
Mwroot
(
talk
|
contribs
)
(Created page with "; 计算两个日期之间差了几年 : =YEARFRAC("2018/9/30","2024/7/1",1) ; 对几年取整,舍弃小数部分 : =TRUNC(sth) ; 往后推算 5 年是哪个日期 : =EDAT...")
Latest revision as of 11:43, 18 June 2024
(
view source
)
Mwroot
(
talk
|
contribs
)
; 往后推算 5 年是哪个日期
: =EDATE("2018/9/30",5*12)
日期注意用英引号扩起来。
Mwroot
Private_Access,
Bureaucrats
,
Interface administrators
,
Administrators
3,135
edits
Navigation menu
Personal tools
Log in
Namespaces
Page
Discussion
Variants
Views
Read
View source
View history
More
Search
Navigation
Main page
Random page
Tools
Special pages
Printable version