Days of the month

[alexm999]

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)?

 

[Rob van Gelder]

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]

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

 

[Rob van Gelder]

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]

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

 

[Rob van Gelder]

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

 

[alexm999]

Thanks Alot!

 

[Peter Atherton]

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+1>EOMONTH(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