01-16-2019 04:50 PM
01-17-2019 02:27 AMSolution
It looks like that's Employee Attendance Record Template.
They use formulas
For the beginning of the month
In the middle of calendar
and at the end of it
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.
01-17-2019 10:36 AM
I copied cells AL through AR and pasted the copied formulas in cells AE through AK and it removed all of the extra days in the month. Now each month only reflects day 1 through 28, 30 or 31 depending on its corresponding last day. Thank you for your help Sergei. I'm still a rookie with excel, but I'm learning everyday.
01-17-2019 10:38 AM
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 :)
01-17-2019 01:06 PM
Now that I've copied the formulas as mentioned the "Key Statistics" box counts are not computing.
The formula in the key stats boxes is as follows:
=SUMIFS(LeaveTracker[Days],LeaveTracker[Employee Name],valSelEmployee,LeaveTracker[Start Date],">="&DATE(Calendar_Year,1,1),LeaveTracker[End Date],"<"&DATE(Calendar_Year+1,1,1))
=SUMIFS(LeaveTracker[Days],LeaveTracker[Employee Name],valSelEmployee,LeaveTracker[Start Date],">="&DATE(Calendar_Year,1,1),LeaveTracker[End Date],"<"&DATE(Calendar_Year+1,1,1),LeaveTracker[Type of Leave],'Leave Types'!B4)
It was computing just fine until I copied and pasted the cells as previously discussed.
01-17-2019 02:51 PM
What do you mean under Not computing? I tested it with Employees #1 and #3, numbers in the boxes are the same.
To change the formula select cells AR6:AR17 and drag selection to the left till middle of the calendar. Please check attached changed file.
01-17-2019 03:05 PM