How To Get The Current Year Using Vba

excel vba date

Year(Date)

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

Explanation of both of these functions from here.

excel vba date

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

CodeHunter