Writing Macro using VBA in Excel

Question

I have already used this code: year() to get the current year. But, I only want the last two digits of the year. Foe example, from today's date 01/19/2017, I only want to pull up and display a message box containing '17'. How can I write this code in Macro using VBA in Excel?

Answer 1

Try this:

MsgBox Format(Date, "yy")