I know this may be a little complicated but maybe someone can help. I am trying to make an excel spreadsheet to track attendance for a rolling 6 months, with consecutive absences counting as 1 occurrence. I have done this by having the dates go consecutively straight down a single row, except for the consecutive absence part. Right now i only have it counting each individual occurrence as one. But i was trying to do it to where it looked more formal, like a regular 12 month calendar, so i can do attendance stats and records by it. I don't know if this would be possible or not. If it is not maybe a different way would be have the linear one that actually tracks it and another sheet that has the monthly calendar that contains information from the other sheet.