Hi,
I've been working my time attendance file, it works fine at first. But as I use it for longer periods I see something that is not included in my template- 1)date that is link to the holidays and 2)work schedule.
What am trying to solve is that once I enter a date in my attendance sheet and that date falls on a holiday (legal or special holiday) the employee who works that day should not be considered as late or absent but rather reflects as overtime work same goes with the work schedule, that if the employee work on a weekend (Saturday or Sunday) which is his rest day, he should not be considered late or absent but an overtime work.
Does this case "link" in excel be recognized. All I could think is I added a another sheet that is the holiday schedule and sheet for the work schedule. Here's my sample.
Thank you
Bookmarks