Hi to all the awesome Excellers!
I have a problem i cant seem to get around, here goes;
I'm using a countif formula for a specific range of cells, but i realise as the months go by, i need the formula to have a dynamic range that will change if and when needed to. I'm using random dates...
Ok, so as the title, i'm tring to make an interactive attendance register. I've pretty much taken the idea from Chandoo's awesome pivot calendar_v1 with the date table on the 1 page (dates going down in 1 column, exactly like the pivot calendar) and a splicer calendar on the next (linked with a...