IS ther any facilities to enter full year calender (by function or ) in Excell

one way:

in A1 insert 2009-01-01
in B1 insert =WEEKDAY(A1,2)
format->cells->custom->format as dddd

in A2 insert A1+1, copy B1 to B2
copy down


On 6 Mar, 08:04, Fareez <Far...@discussions.microsoft.com> wrote:
> IS ther any *facilities to enter full year calender (by function or ) in Excell

Hi,

Microsoft has a whole set of template calendars for Excel. Start from here:

http://office.microsoft.com/en-us/ex...179621033.aspx

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Fareez" wrote:

> IS ther any facilities to enter full year calender (by function or ) in Excell

Hi Fareez,

I have made calender in excel and uploaded in savefile web.

You can view it from following link.

http://www.savefile.com/files/2029093

H S Shastri


++++++++++++++++++++++++++++++++++++++++++++++++++++++++

"Fareez" wrote:

> IS ther any facilities to enter full year calender (by function or ) in Excell