Good morning! Just joined the forum this morning and looking to get some advice from Excel experts. Currently trying to figure out how to build an attendance tracker for a rolling 90-day window. I have 45 employees and we just implemented a new attendance policy and I need to keep track of absences. Nothing too advanced, just want to know at a glance how many days a person has missed work on any given day over the past 90 days. I have some Excel skills with formulas, but not nearly advanced enough to use indexes and vlookup functions. Any suggestions will be greatly appreciated!
Thanks
Matt
Bookmarks