View Single Post
  #1   Report Post  
Ajit Munj
 
Posts: n/a
Default Days in Calender

I have entered 01.02.2005 in A1 and format the cell as "mmmm, yyyy"
to show as "February, 2005". Now I want excel to calculate
the no. of days in Feb, 2005 and show the days as Mon, Tue,
Wed...etc from cell b2 to ab2 and date as 1,2, 3 ... from c3
to ac3. If I put 01.03.2005 in A1 to show March, 2005, excel
should calculate 31 days and show the days as Mon, Tue etc.
from b2 to ae2..
Thansk
Ajit

--
Knowldege is Power