Modify MS template?

[squirrellydw]

How can I modify the MS spreadsheet so it counts weekends? They are currently grayed out and I need it to count all the days of the year since we never close. Also is there away to have it show each employee's days days off on the calendar view? The template is found by typing in "Employee" and it's called "Employee Attendance Record" Picture of it is attached

 

[HighAndWilder]

How can I modify the MS spreadsheet so it counts weekends? They are currently grayed out and I need it to count all the days of the year since we never close. Also is there away to have it show each employee's days days off on the calendar view? The template is found by typing in "Employee" and it's called "Employee Attendance Record" Picture of it is attached

Can you please submit this sheet using XL2BB so that we can see how it is put together.

XL2BB - Excel Range to BBCode

 

[squirrellydw]

It's a built in template in excel. I also can't use XL2BB since it's a work computer.

 

[HighAndWilder]

It's a built in template in excel. I also can't use XL2BB since it's a work computer.

I've found it.

Bear in mind that this is a Sick leave / Vacation / Bereavement / Other Tracker and not a Days Worked Tracker.

The font color for weekends can be changed by changing the font color in the last Conditional Format for the =$C$6:$AR$17 range.
This is just a formatting change.

The calendar is based around the assumption that weekends are not working days BUT there are ways around this.

Before I address how that can be done, how are days off structured because for each employee these will need to be recorded.
This may be an overhead that is not workable.

If there is an overlap between the days recorded as Sick leave / Vacation / Bereavement / Other then how do you want these to be counted?
If someone is sick whilst on vacation then how is this to be counted?
If a relative dies when someone is off sick then how is this to be counted?

 

[squirrellydw]

Each employee has different days off, I was hoping I could have a section next to there name that I can input there days off and it would show on the calendar but I realize that may not be possible. I'm not worried about overlap, if they are sick while on vacation it's still counted as vacation. And if someone dies it's still sick, I was actually going to change the bereavement to FMLA. Hope that helps answer your questions.

 

[HighAndWilder]

Each employee has different days off, I was hoping I could have a section next to there name that I can input there days off and it would show on the calendar but I realize that may not be possible. I'm not worried about overlap, if they are sick while on vacation it's still counted as vacation. And if someone dies it's still sick, I was actually going to change the bereavement to FMLA. Hope that helps answer your questions.

Do employees ALWAYS have the same days off per week? If this is NEVER to be the case then each period that they have off will need to be recorded. This can be semi automated.

 

[squirrellydw]

yes for the most part. They bid for their days off once to twice a year. So someone could have off Friday and Saturday and then they might change to have off Saturday and Sunday off. Even if I would have to add their days off manually on the calendar that would work. For example if they are off Friday and Saturday and if I could show that by making those days BOLD and they wouldn’t be counted in the formulas if that makes sense. Does that make sense?