calender
 

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

calender
 

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 wrote:
IS ther any *facilities to enter full year calender (by function or ) in Excell

calender
 

Hi,

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

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

calender
 

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

Clicked the link.... no calender. Am I missing something?

K[


QUOTE='HARSHAWARDHAN. S .SHASTRI[_2_];806157']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[/quote]