Display number of day of month depending on the year

[Guest]

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

 

[Guest]

Ok! I got it. The formula is, at A1 type

=TEXT(A2,"dddd")

But before you continue, you need to understand some basic. Suppose! if A2
is = 1 then according to the formula it will show no. 1 as Sunday and no. 2
as Monday and so on and 1st January 2006 is also Sunday. So formula is
suitable only for the years which has 1st January as Sunday.

If you want the same formula to work for every year. Then you need to change
something in your data.

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

As per your example, you are typing numbers 1 - 2 - 3 as Days. Is in it?

You have to change them to date (e.g. 1/1/2006) but you need them to display
as number like "1".

Type 1/1/2006 in A2.

Right-click Format Cell - on the Number tab click Custom and in the "Type"
box type only "d" without quotes click Ok. Now, excel will show the complete
date as 1. Drag this cell to another once and the format will automatically
be copied.

You can use this method for any year, any month and any date. It will show
you the correct Character Day of Week.

Hope this information helps you. I will appreciate your comments on this
post. You need to do a little bit hard-work to understand this.