Excel 2007 : Make a Calendar in excel that puts the date under the correct day of the week

Hi,

following on from my payroll calendar I now want a calendar that auto populates where the date goes on a calendar template I have produced.

So for example i want the calendar to have the dates of that month put in under the corect day of the week

Example in June 2010 01/06/2010 was a tuesday, so the dates in the month would be put in the calendar starting under tuesday.

My layout essential lists the days of the week across the top and I want it to display the date e.g. 1 2 3 4 5 etc

The layout:

June 2010

Sunday Monday Tuesday Wednesday Thursday Friday Saturday

here is my project so far and on the sheet called calendar is the spec of what i want it to do. i also saw this post about a vba calendar creator does any one think this idea would work and if so how do i do it?

http://www.ozgrid.com/forum/attachme...4&d=1147461706

thats the file

this is the post:

http://www.ozgrid.com/forum/showthre...light=calendar