Help please! I have a calendar that I'm trying to get the current date to change format by using a conditional formula and TODAY(). I think there is something in the programing that won't allow this operation. The spreadsheet is set up like this:

cell B2 = 1/1/2007
cell J2 =DATE(YEAR(B2),MONTH(B2)+1,1) (This gives me my month, Feb.)

cell J4 =(WEEKDAY(J2)=1)*J2 (This gives me my 1st day of the month)
cell K4 =(WEEKDAY(J2)=2)*J2+(J40)+J4 (This gives the 2nd day)
cell L4 =(WEEKDAY(J2)=3)*J2+(K40)+K4 (This gives the 2rd day)
cell M4 =(WEEKDAY(J2)=4)*J2+(L40)+L4 (This gives the 4th day)
cell N4 =(WEEKDAY(J2)=5)*J2+(M40)+M4 (The 5th day)
cell O4 =(WEEKDAY(J2)=6)*J2+(N40)+N4 (The 6th day)
cell P4 =(WEEKDAY(J2)=7)*J2+(O40)+O4 (The 7th day)
cell J5 =+P4+1 (The 8th day)
cell K5 =+J5+1 (The 9th day)
cell L5 =+K5+1 (The 10th day)

This +1 of the previous cell continues to the end of the month. All 12 months are set up the same way.

What am I doing wrong? Can't get the conditional formula to change the current day in the month to a different format ..... very frustrating!

Thanks for your help.