Posted to microsoft.public.excel.worksheet.functions

Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline

external usenet poster

Posts: 896

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
pop up calender	pezcore	Excel Discussion (Misc queries)	2	October 18th 07 02:15 PM
calender	S S	Excel Worksheet Functions	1	July 26th 07 11:57 PM
Calender	Antney	Excel Discussion (Misc queries)	0	December 11th 06 10:42 PM
CALENDER	smickParisTX	Excel Discussion (Misc queries)	0	January 19th 06 06:19 PM
Calender Help	Alexanderj	Excel Worksheet Functions	3	November 10th 05 02:10 PM

All times are GMT +1. The time now is 11:57 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us