Forum Discussion
Excel Calendar adding extra days.
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.
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)
