利用EXCEL本身有计算系统当前时间的函数now()或当前日期的函数today()和从指定日期中截取年度的函数year()。组合可计算出系统当前日期的“年”,完整公式如下:=year(now())或=year(today())
=text(now(),"yyyy年")
=year(today())
=year(today()),或者=year(now())
YEAR(NOW())