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.
Formula:
Please Login or Register to view this content.
I tried the following:
Formula: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!
Last edited by notnutts; 03-17-2016 at 01:23 PM.
How about this formula:
You count all the event for this employee and then you substract the ones you know (Sick, Vacation, Bereavement).
Please Login or Register to view this content.
Does it make sense?
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
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.
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.
That works great. Where is the formula at? I'd like to take a look at it so I can learn a bit. Thanks!
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.
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?
Last edited by Del209; 05-30-2019 at 08:06 AM.
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]]
Last edited by SyedTabassumAli; 07-12-2019 at 03:34 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks