Excel Attendance Tracker

[Wendi1525]

Hello

I am using the excel attendance tracker to keep a record of my employees call offs, tardiness etc. I know it is set up to counts all days except weekends and holidays. My need is for all 365 days. When I put information in the tracker and it is a weekend day or holiday, it does not show up as a tracked day in the counts but does show on the calendar. Can someone show me how I can get it to also track these days?

Thank you

[6StringJazzer]

Welcome to the Forum Wendi1525!

Your question is generic and cannot be answered without seeing the specifics of your data and formulas. Please attach a workbook with sample data that demonstrates your question, with a description of what you need it to do including specific worksheet/cell references.

[Wendi1525]

Annual Attendance Calendar - Fillable.xlsx

The counts on the bottom for types of leave are not calculating correctly. If the employee calls in sick on the weekend or holiday, it is not counting those days in the leave counts.
I figured out how to get it to show on the calendar, but the labor count is not updating on the bottom of the page. The workbook was made to ignore the counts for weekends and holidays,
but I need it to count those days as we are open and running 365 days of the year.

Hope this clarifies what I am asking.

[6StringJazzer]

I'm having trouble tracking the issue. As I mentioned before, can you point to specific cells and values that show what the problem is?

[Wendi1525]

Employee attendance record 2024.xlsx

ok, on this example, if you look at the employee Susan Chacko, she has 2 S-PTO days on the calendar, but because they are weekend days, dates 3/2 and 4/27, they are not counting below in the labor counts.

These are cells I8 and AD9

Thank you

[JeteMc]

On the Employee Leave Tracker sheet paste the following into cell F4 and copy down: =DAYS([@[End date]],[@[Start date]])+1
Let us know if you have any questions.

[Wendi1525]

That worked perfectly THANK YOU!!!

[JeteMc]

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.