1 question

### Formula not working correctly

when formulating a two page expression, the first page is not reading the second expression. I have given you the two formulas - I would hopefully like to have this sorted; if possible.

the first one should denote the year: In this case 2020

=IF(MONTH(\$A\$5)<>MONTH(\$A\$5-(WEEKDAY(\$A\$5,1)-(\$I\$2-1))-IF((WEEKDAY(\$A\$5,1)-(\$I\$2-1))<=0,7,0)+(ROW(A7)-ROW(\$A\$7))*7+(COLUMN(A7)-COLUMN(\$A\$7)+1)),"",\$A\$5-(WEEKDAY(\$A\$5,1)-(\$I\$2-1))-IF((WEEKDAY(\$A\$5,1)-(\$I\$2-1))<=0,7,0)+(ROW(A7)-ROW(\$A\$7))*7+(COLUMN(A7)-COLUMN(\$A\$7)+1))

The second shouldgive me the first day of the year:

=IF(MONTH(\$A\$5)<>MONTH(\$A\$5-(WEEKDAY(\$A\$5,1)-(\$I\$2-1))-IF((WEEKDAY(\$A\$5,1)-(\$I\$2-1))<=0,7,0)+(ROW(A7)-ROW(\$A\$7))*7+(COLUMN(A7)-COLUMN(\$A\$7)+1)),"",\$A\$5-(WEEKDAY(\$A\$5,1)-(\$I\$2-1))-IF((WEEKDAY(\$A\$5,1)-(\$I\$2-1))<=0,7,0)+(ROW(A7)-ROW(\$A\$7))*7+(COLUMN(A7)-COLUMN(\$A\$7)+1))

Question, is this even possible?
130 views Rev.Michael
Oct 01, 2020 at 01:28 AM

### Formula not working correctly

when formulating a two page expression, the first page is not reading the second expression. I have given you the two formulas - I would hopefully like to have this sorted; if possible.

the first one should denote the year: In this case 2020

=IF(MONTH(\$A\$5)<>MONTH(\$A\$5-(WEEKDAY(\$A\$5,1)-(\$I\$2-1))-IF((WEEKDAY(\$A\$5,1)-(\$I\$2-1))<=0,7,0)+(ROW(A7)-ROW(\$A\$7))*7+(COLUMN(A7)-COLUMN(\$A\$7)+1)),"",\$A\$5-(WEEKDAY(\$A\$5,1)-(\$I\$2-1))-IF((WEEKDAY(\$A\$5,1)-(\$I\$2-1))<=0,7,0)+(ROW(A7)-ROW(\$A\$7))*7+(COLUMN(A7)-COLUMN(\$A\$7)+1))

The second shouldgive me the first day of the year:

=IF(MONTH(\$A\$5)<>MONTH(\$A\$5-(WEEKDAY(\$A\$5,1)-(\$I\$2-1))-IF((WEEKDAY(\$A\$5,1)-(\$I\$2-1))<=0,7,0)+(ROW(A7)-ROW(\$A\$7))*7+(COLUMN(A7)-COLUMN(\$A\$7)+1)),"",\$A\$5-(WEEKDAY(\$A\$5,1)-(\$I\$2-1))-IF((WEEKDAY(\$A\$5,1)-(\$I\$2-1))<=0,7,0)+(ROW(A7)-ROW(\$A\$7))*7+(COLUMN(A7)-COLUMN(\$A\$7)+1))

Question, is this even possible?
130 views Rev.Michael
Oct 01, 2020 at 01:28 AM