Create a Calendar by Month and Year.

[How_Do_I]

Hi all…
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Is there a way to do this please… using C2 (Month) and C3 (Year) is it possible to populate my yellow area under the days.
<o> </o>
So in this example because 01 Jan 1943 is a Friday then 1 is under Friday etc. Other month / year combinations need to work.
<o> </o>
I found this macro that works but is this possible with a formula please?
<o> </o>
http://support.microsoft.com/kb/150774
<o> </o>
This works for the current month but I need to be able to select month and year…
<o> </o>
http://www.techjive.net/2007/02/11/excel-calendar-trick/
<o> </o>
Any ideas please?

Excel Workbook
	A	B	C	D	E	F	G
1		Day	1
2	Friday	Month	Jan
3		Year	1943
4		Day Name	Friday
5
6	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
7						1	2
8	3	4	5	6	7	8	9
9	10	11	12	13	14	15	16
10	17	18	19	20	21	22	23
11	24	25	26	27	28	29	30
12	31
Sheet1

 

[meldoc]

Hi Gus

See the link.

http://spreadsheetpage.com/index.php/file/array_formula_calendar/

 

[AlphaFrog]

• Copy the formula below
• Select a 7-col by 6-row range (A7:G12)
• Press F2
• Press Ctrl+V to paste the formula into the active cell
• Press Ctrl+Shift+Enter (to make it a multicell array formula)
• Format the cells using the Custom number format; Type: d

=IF(MONTH((C2& " 1, " &C3)*1)<>MONTH((C2& " 1, " &C3)*1
-(WEEKDAY((C2& " 1, " &C3)*1)-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),"",
(C2& " 1, " &C3)*1-(WEEKDAY((C2& " 1, " &C3)*1)-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)

 

[tusharm]

You should be able to adapt the work at
A calendar template
http://www.tushar-mehta.com/excel/templates/calendar/index.html

I've also submitted several templates to http://office.microsoft.com/en-us/marketplace/ but I can never find anything I want there. Maybe, it's just me...

Hi all…
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Is there a way to do this please… using C2 (Month) and C3 (Year) is it possible to populate my yellow area under the days.
<o> </o>
So in this example because 01 Jan 1943 is a Friday then 1 is under Friday etc. Other month / year combinations need to work.
<o> </o>
I found this macro that works but is this possible with a formula please?
<o> </o>
http://support.microsoft.com/kb/150774
<o> </o>
This works for the current month but I need to be able to select month and year…
<o> </o>
http://www.techjive.net/2007/02/11/excel-calendar-trick/
<o> </o>
Any ideas please?

Excel Workbook
	A	B	C	D	E	F	G
1	*	Day	1	*	*	*	*
2	Friday	Month	Jan	*	*	*	*
3	*	Year	1943	*	*	*	*
4	*	Day Name	Friday	*	*	*	*
5	*	*	*	*	*	*	*
6	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
7	*	*	*	*	*	1	2
8	3	4	5	6	7	8	9
9	10	11	12	13	14	15	16
10	17	18	19	20	21	22	23
11	24	25	26	27	28	29	30
12	31	*	*	*	*	*	*
Sheet1

 

[How_Do_I]

Thanks all, I'm quickly dropping in here as my fingers are in other pies at the moment. Will try some of these ideas out ASAP etc... Thanks.