如何使用 Vba 获取当前年份

How To Get The Current Year Using Vba

提问by Karthik

I am trying to get the current year using VBA. Is there any pre-build function available to find out the current year?

我正在尝试使用 VBA 获取当前年份。是否有任何预构建功能可用于查找当前年份？

回答by mechanical_meat

Year(Date)

Year(): Returns the year portion of the date argument.
Date: Current date only.

Year()：返回日期参数的年份部分。
Date: 仅限当前日期。

Explanation of both of these functions from here.

从这里开始解释这两个功能。

回答by Jeffrey Imran

Try =Year(Now())and format the cell as General.

尝试=Year(Now())将单元格格式化为General.