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
.
精彩评论