Hi, A Way!! In your Worksheet go to insert > name > define -Type m in the
top box,in the bottom box type =11 click add > ok. Repeat process for y but
bottom box type =2005. This is for this Year and November. Next copy the
formula below, select the cell you wish to start the calendar, Paste in this
formula, Extend the selection to a grid of 7 wide by 6 down, put the
insertion blinker into the cell with the formula then press command enter
together as this is an array. When you enter the formula it will show the
date serial number. To show a single number in each cell go to > format >
cells > custom > type box Enter: d click OK. The first column is a Sunday.
With this still selected you can then format it to your liking.
=DATE(y,m,1)-(WEEKDAY(DATE(y,m,1))-1)+{0;7;14;21;28;35}+{0,1,2,3,4,5,6}
--Paul.
