Need help editing employee attendance tracker

[notnutts]

I'm having trouble bending the template to my will. I added some "types" on the settings tab, but they don't display on the calendar view tab. I think it is the formula in cel AR26, which follows.

Please Login or Register  to view this content.

I tried the following:

Please Login or Register  to view this content.

But it didn't work. I want any employee absence listed on the second tab to display on the calendar tab. Please help!

[p24leclerc]

How about this formula:

Please Login or Register  to view this content.

You count all the event for this employee and then you substract the ones you know (Sick, Vacation, Bereavement).
Does it make sense?

[notnutts]

That works like a champ, except it does not color in the calendar. I'm not overly familiar with arrays, so this may be easy.

[p24leclerc]

As the formula for the conditional formatting is very long, please refer to the attached workbook.
It seems to highlight every conditions and it also count them right.
If you add new attendance reasons, you'll have to change the condition formatting formula.

[notnutts]

That works great. Where is the formula at? I'd like to take a look at it so I can learn a bit. Thanks!

[p24leclerc]

To see the formula, you first click on any cell in your calendar then you edit the YELLOW conditional formatting. The easiest way to see and study those long formulas is to copy them to an empty cell in your workbook. The result will not be the same but you'll be able to look it around and see it in full if you want.

[Del209]

I am having the same issue with this sheet. I have everything coded correctly, however, While it does highlight the specified days, It doesn't record them in the counter. It doesn't record weekends. Is there any way to code so the counters at the bottom of the page display the correct count w/ the shaded areas including weekends?

[SyedTabassumAli]

Hi I have been working on a template like this, The problem here is that it doesn't count the Weekends ("Saturday & Sunday") in Leaves count, even if there are sandwich leaves.
It will only count leaves for working days, If you count from Date 2nd to Date 9th the total is 8 but if you remove 2 weekends then the count is correct "6".
This will do the trick
On Leave Tracker Sheet, Under Days (F4) Replace ([@[Start Date]],[@[End Date]],lstHolidays) with ([@[End Date]]+1)-[@[Start Date]]