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/

A1: 1-Jan-2004
A2: 2-Jan-2004
A3: ...

B1: =A1
B2: =A2
B3: ...

Select Column A. Set the cell format to d
Select Column B. Set the cell format to dddd

Rob


"alexm999 " wrote in 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/

I can fill out the sheet for January, but how do i get it to
automatically change in February?


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

In that case.
A1: 1-Jan-2004
A2: =A1+1
A3: ...

Then whenever you want a new month, just change the date in A1


"alexm999 " wrote in message
...
I can fill out the sheet for January, but how do i get it to
automatically change in February?


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

Code doesnt work, i'm getting a #value in the cell...


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

Should work, which cell are you getting #VALUE in?


"alexm999 " wrote in message
...
Code doesnt work, i'm getting a #value in the cell...


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

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/

.