Days of the month

  • Thread starter Thread starter alexm999
  • Start date Start date
A

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)?
 
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
 
I can fill out the sheet for January, but how do i get it to
automatically change in February?
 
In that case.
A1: 1-Jan-2004
A2: =A1+1
A3: ...

Then whenever you want a new month, just change the date in A1
 
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
 
Back
Top