Problems with showing the correct number of days in a month?! HELP!!!!

[bftznk]

Sometimes there are 28/29/30/31 days in a month in a year, right?! What's the simplest ways to meet the following task?

1. The Year or/and month can be change
2. Once the date is change the Week of days in different(Mon, Tue...) would also be changed correctly
3. Show correctly if there are 28/29/30/31,

Do I need to use VB,Marco or
someting else?! Plz Help!

 

[miss_ell]

Hello,

My formulas are working quite well.

It shows the wrong days of the week because you're now using a different table from what you originally specified. You really needed to show us the actual table format you are using for us to be of any help. Your dates are showing vertically now instead of horizontally for a start!

A2 = enter year
B2 = enter month number
C2 =DATE(A2,B2,1), format to "d"
D2 =C2, copy down to D32
E2 =C2, format to "ddd", copy down to E32

A3 =IF(ISERROR(YEAR(C3)),"",YEAR(C3)), copy down to A32
B3 =IF(ISERROR(MONTH(C3)),"",MONTH(C3)), copy down to B32
C3 =IF(ISERROR(IF(C2+1 > EOMONTH(C2,0),"",C2+1)),"",IF(C2+1 > EOMONTH(C2,0),"",C2+1)), copy down to C32.

Result:

Year	Month	Date		Day
2013	1	1	01/01/2013	Tue
2013	1	2	02/01/2013	Wed
2013	1	3	03/01/2013	Thu
2013	1	4	04/01/2013	Fri
2013	1	5	05/01/2013	Sat
2013	1	6	06/01/2013	Sun
2013	1	7	07/01/2013	Mon
2013	1	8	08/01/2013	Tue
2013	1	9	09/01/2013	Wed
2013	1	10	10/01/2013	Thu
2013	1	11	11/01/2013	Fri
2013	1	12	12/01/2013	Sat
2013	1	13	13/01/2013	Sun
2013	1	14	14/01/2013	Mon
2013	1	15	15/01/2013	Tue
2013	1	16	16/01/2013	Wed
2013	1	17	17/01/2013	Thu
2013	1	18	18/01/2013	Fri
2013	1	19	19/01/2013	Sat
2013	1	20	20/01/2013	Sun
2013	1	21	21/01/2013	Mon
2013	1	22	22/01/2013	Tue
2013	1	23	23/01/2013	Wed
2013	1	24	24/01/2013	Thu
2013	1	25	25/01/2013	Fri
2013	1	26	26/01/2013	Sat
2013	1	27	27/01/2013	Sun
2013	1	28	28/01/2013	Mon
2013	1	29	29/01/2013	Tue
2013	1	30	30/01/2013	Wed
2013	1	31	31/01/2013	Thu

<COLGROUP><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2596" span=4 width=71><COL style="WIDTH: 48pt" width=64><TBODY>
</TBODY>

Let me know how it works out.

 

[bftznk]

wow, it works vertically, let see if it work horizontally Thx,you are genius, Any books or tranning you can recommend?!