Record a macro using VBA in Excel

Question

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

Answer 1

Try the following:

MsgBox Format(Date, "yy")