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.
Hi Sir,
I would like to change the holiday from sat sun to Friday.
Could you plz help me for that
See my previous reply in this discussion. If you want Friday as the only weekend day, use NETWORKDAYS.INTL with 16 as 3rd argument.
For example, with dates in A2 and B2:
=NETWORKDAYS.INTL(A2, B2, 16)
