Forum Discussion
Chairod
Jan 17, 2019Copper Contributor
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?
- Jan 17, 2019
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.
SergeiBaklan
Jan 17, 2019MVP
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.
liteshine
Dec 04, 2023Copper Contributor
Sergei, could you explain which part of the formula takes off the extra days?
I have the following in mine currently:
=IFERROR(IF(W6>=1,W6+1,""),"")
it's adding 4 days on to the end of the months currently.
I have the following in mine currently:
=IFERROR(IF(W6>=1,W6+1,""),"")
it's adding 4 days on to the end of the months currently.
- liteshineDec 06, 2023Copper ContributorWhen I try to use the =IFERROR(IF(AND(AG6>=1,AG6+1,<=DATE(Calendar_Year,ROW($A1)+1,0)),AG6+1,""),"")
it gives me the following error:
there's a problem with this formula.
not trying to type a formula?
when the first character is an equal (=) or minus (-) sign, excel thinks it's a formula.
etc. etc.- HansVogelaarDec 06, 2023MVP
In
=IFERROR(IF(AND(AG6>=1,AG6+1,<=DATE(Calendar_Year,ROW($A1)+1,0)),AG6+1,""),"")
there is no cell reference before <=
It's not clear what you're trying to do...