Calendar

Starting with cell A1, type in Monday, Tuesday, etc. across through Sunday in G1. Then in A2, copy this formula:

=IF(ROW()=2, IF(COLUMN()=1, IF(TEXT(DATE(2008,1,1),"dddd")=A1, DATE(2008,1,1),""), IF(OFFSET(A2,0,-1)="", IF(TEXT(DATE(2008,1,1),"dddd")=A1, DATE(2008,1,1),""), OFFSET(A2,0,-1)+1)), IF(COLUMN()=1, G1+1, OFFSET(A2,0,-1)+1))

Copy that across through column G, then down as far as you need. This will start with 1/1/2008 in the proper column.

Is that what you are looking for?

Hi Jasoncw
I think I am almost there, but not quite. Your formula produces full dates (i.e day,month & year). I want only the day of the month (1 or 2 or 3, ...or 31) to appear in each cell. Could you please modify the formula to achieve this. Thank you.

Hi, formula doesn't need to change. Just format cells as "d". You will only get the day of the month

Hi Arthurbr
Could you please explain to me how to format cells as "d" to get the day only of the date? I tried but could not do it. I am using Excel 2003.
Thank you

Highlight cells, right click, format cells..., custom, type d in the box, OK.

Thank you Darkyam.
Your advice helped me out. The problem is now solved

If your problem is solved, please change your original title prefix to " solved" via Edit - Go Advanced

How about his for a revision?

=DATE(2008,1,COLUMN()+7*(ROW()-2)-1)

Or, a year-indifferent version (works for 2009!)
=DATE(YEAR(NOW()),1,COLUMN()+7*(ROW()-2)-WEEKDAY(DATE(YEAR(NOW()),1,1),3)

In every cell from A1 through G54 - format top line as "dddd", format rest as "d".

tres neat, non?