Back again, this time with a yearly attendance tracker issue I'm unable to solve with my limited knowledge.
The template itself is something I got off the interweb, and I was able to add the coloumns in the beginning and have the lookups work (I think).
Couloumns NU:OF is what I cant seem to get my head around, no matter how much I try fiddling with the Offset formula.
What I would like the sheet to do is:
give me the total monthly leaves in coloumn NU, total annual leaves in NV and the monthly break-up in coloumns NW:OF (the leave codes are in coloumn OI)
The holidays sheet and its functionality is something that I don't need, but I had to leave it in because it crashed the entire thing when i tried removing it.
What would be great, too, is if the experts could simplify the Offset formula for me, if it isn't too much to ask for. I get the basics, as in it looks x rows down and across, and returns the value there, but I fail to understand how that works when the calendar changes to the next month.
I did try searching on here as well as other places for a similar issue, and did run across one where the author was having issues inserting coloumns in the beginning, but that was about it, so I'm here once again.
Hope someone can shed some light on the situation.