Mathematics Problem

[taichiperson]

I'm in my mid fifties, and the furthest I got in Maths at school was O'level, which I just scraped past. I understand the principals of simple Maths, but I think I have mild discalculia, as I can never fix numbers in my head once I get past tens and units. I'm self employed and use a spreadsheet for my finances. I'd like to use some formulas, but don't even know how to begin beyond the simplest ones. I don't even know what branch of Maths I need to use.

The formula I'm stuck on goes like this; I run exercise classes in towns and villages nearby, but of course the classes don't run 52 weeks of the year. I need a formula that will count the number of weeks out of 52 that the class ran so that I can calculate mileage and room hire etc without having to physically run down the column with my finger, counting the number of classes.

I'd be grateful if someone could tell me what formula to use, and point me to the right branch of mathematics to find out for myself what the process behind the formula is - is it logic? algebra?

Thanks in advance

[jim360]

Glad to hear it's all sorted out. Spreadsheets can be tricky to work with even at the best of times.