14 Day Tracker

14 Day Overnight Tracker.xlsxIm a security guard and im in charge of keeping track of people that spend the night in the facility i guard. they can only spend 14 days over a 12month people then they get a 30day ban. well i came up with a tracker that works for the most part but with the volume of people that enter and exit the building and stay over it gets to be a pain. im trying to make it to were it will keep track of every person and keep a running tally of how many nights they have stayed over. right now it keeps track of them on a monthly basis but then i have to go back each month and count up the days in past months that said person stayed over its a pain. im just looking for a way to streamline it.


https://www.dropbox.com/s/mwvmcre18i...cker.xlsx?dl=0