Attendance Database

[jenmears]

I can easily put together a list of employees, a count of how many days they missed in a month, and even calculate how many missed in last 90 days.
I'm trying to figure out how to change that 90 days (or search for a specific time) without having to re-formula each time I want to change which 90 days to search.

If anyone could point me in the right direction. Looking to enhance how we look at attendance tracking only. Don't need the extras of payroll, scheduling, extra - so I can't seem to find a narrowed down template or application to help me.


Thanks.

[royUK]

maybe if you attach an example workbook we can see how your data is arranged 7 offer more help.

[jenmears]

This is a very basic look for attendance. I believe I will just import all the information in from other sheets to be more put together and keep updated.
My issue is still just being able to get a count of how much absences during a certain period, etc.