you already found the solution on your own, you have to create seperate month and year fields from your date field during load.
Don't worry about additional load in QV and don't waste any efforts in extending your excel source.
The script extension could look like this:
LOAD date, Year(date) as year, Month(date) as month FROM your.xls;
hope this helps