|Glad you came up with your own solution.|
Here is one that uses the DATE function, might be a bit easier to understand:
Notice I did NOT surround 2006 with quotes.
When you surround a number with quotes, it becomes TEXT
and could cause confusion, unless you want the 2006 to be a text string.
Also, Excel questions are best asked in the Office Software Forum.