Well the reason it won't compile could be because you've declared a variable called day.

And since Day is a VBA function that's not a good idea.