I'm sorry, I should've already posted this. Here is how I am currently doing this:

Cell A1 is where the month/year is entered
Cells D2 - AH2 are manually numbered 1-31
Days of the week are done using =TEXT($A$1,"ddd"), next cell is =TEXT($A$1+1,"ddd"), etc