Alex

Here is another way - it will change automatically each
month.
in A2 enter =DATE(YEAR(NOW()),MONTH(NOW()),1)
in a3 enter =A2+1 and copy down to A29 (to get to the 28th)
in a 30 enter =IF(A29+1EOMONTH(A29,1),"",A29+1) and copy
this down to A30.
Custom Format this column to dd
in b2 enter =WEEKDAY(A2) and copy down then format to ddd

Regards
Peter
-----Original Message-----
How do I list the days of the month with the
corresponding day
vertically in 2 columns:

For example:
A B
1 Monday
2 Tuesday
3 Wednesday
4 Thursday


And so on all the way to the 31st or 30th (depending on
month)?


---
Message posted from http://www.ExcelForum.com/

.