Forum Discussion
Excel Calendar adding extra days.
Anyone know how to eliminate the extra days being added to the end of each month on this Microsoft calendar?
It looks like that's Employee Attendance Record Template.
They use formulas
For the beginning of the month
=IFERROR(IF(TEXT(DATE(Calendar_Year,ROW($A1),1),"ddd")=LEFT(C$5,3),DATE(Calendar_Year,ROW($A1),1),""),"")
In the middle of calendar
=IFERROR(IF(R6>=1,R6+1,""),"")
and at the end of it
=IFERROR(IF(AND(AM6>=1,AM6+1<=DATE(Calendar_Year,ROW($A1)+1,0)),AM6+1,""),"")
You may safely copy cell from the end of the calendar with latest formula (e.g. in column AR) and paste it into the cells starting, let say, from column X or so.
Hello,
can you post the formula that created the day number?
Ingeborg - thank you for responding. I received an answer that helped me, but I didn't want to leave you unrecognized. Thank you for being willing to assist me :)
