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