ExcelBanter - calendar

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.

On 17/11/05 2:15 PM, in article
, "Tushar Mehta"
wrote:

In article ,
says...

how can i create a calendar using microsoft excel?

A possible starting point:
A calendar template
http://www.tushar-mehta.com/excel/te..._calendar.html