开发者

How To Get The Current Year Using Vba

I am trying to get the current year using VBA. Is there any pre-build function available to find o开发者_如何学运维ut the current year?


Year(Date)

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

Explanation of both of these functions from here.


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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜