Need help for Date Formula

[firstWeMeet]

Hi, My date formula is not working, anyone has a suggested formula for this setup?
this is my setup
G3=2011 (year)
J3=1 (representing the month which is January)
C12=IF(OR(G3="",J3=""),"No Year and Date",DATE($G$3,$J$3,1))
C12 will automatic appear the month.
M3=1 (representing the start of Day)
C14=INDEX({"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"},1+MOD($M$3+1-2,7))
C14 and below will automatic for a Day (like Sunday, Monday, and the rest Day)

Now! the problem is for my E14 and below is not responding for a date such as 1 to 31, my formula for E14 and below is this:
=IF(MONTH($C$12)<>MONTH($C$12-(WEEKDAY($C$12,1)-($M$3-1))-IF((WEEKDAY($C$12,1)-($M$3-1))<=0,7,0)+(ROW(E14)-ROW($E$14))*7+(COLUMN(E14)-COLUMN($E$14)+1)),"",$E$14-(WEEKDAY($E$14,1)-($M$3-1))-IF((WEEKDAY($C$12,1)-($M$3-1))<=0,7,0)+(ROW(E14)-ROW($E$14))*7+(COLUMN(E14)-COLUMN($E$14)+1))

 

[cgcamal]

Hi firstWeMeet,

What the formula in E14 is intended to do?

Regards.

 

[firstWeMeet]

a formula that will show the date from 1 to 31 base from the year and month selected.
E14 below.

 

[cgcamal]

Sorry, it's not clear enough for.

Probably is not what you want, but to get date from those values something like this could be done.

Excel Workbook
	C	D	E	F	G	H	I	J	K	L	M
3					2011			1			1
4
5
6
7
8
9
10
11
12	01/01/2011
13
14	Sunday		01/01/2011
...

Cell Formulas
Range	Formula
C12	=IF(OR(G3="",J3=""),"No Year and Date",DATE($G$3,$J$3,1))
C14	=INDEX({"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"},1+MOD($M$3+1-2,7))
E14	=DATE(G3,MONTH(C12),DAY(C12))

Hope this helps, if not please explain with details what you need as output
and which values are the input,

Regards.

 

[firstWeMeet]

the 1 for january 2011 is located at Saturday, since the C14,15,16,17 and soon has a formula that set the Day (Sunday,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday) and hope to find a formula that will auto set the Date that not included the Year and month just the date, (1 to 31).

 

[cgcamal]

Please upload or show a sample of your data to know all cells involved.

You can upload an excel file using a free file sharing service or hotmail skydrive or something like that. To show a snapshot you can use MrExcel HTML Maker or Excel Jeaniehttp://www.excel-jeanie-html.de/index.php?f=1

Regards.