Thanks JE, its amazing! But will you pl. explain me the why column()-2 is used?
How does it work? I am not able to work out?
Ajit

"JE McGimpsey" wrote:

one way (your ranges are a bit confusing, but you should be able to
adapt):

B2: =IF(B3<"",B3,"")
B3: =IF(MONTH($A1+COLUMN()-2)=MONTH($A1),$A1+COLUMN()-2,"")

Format B2 as

Format/Cells/Number/Custom ddd

Format B3 as

Format/Cells/Number/Custom d

Copy B2:B3 across to AE2:AE3

Format B1 as mmmm,In article
,
Ajit Munj wrote:

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