View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dn_
 
Posts: n/a
Default Display number of day of month depending on the year

Is it possible to create a calendar-style layout, such that the number of a
day within a month (eg 1st January) appears underneath the day for which it
applies in that month (eventually producing 12 blocks for a particular year,
in which the day is displayed on the top row and the correct number appears
below each day for each week)

Example: 1st Block - January 2006 (The first of Jan06 is a Sunday)
Sunday Monday Tuesday etc
1 2 3
8 9 10