I am after some help from an excel expert for a formula that has me stumped.
I have a tracking spreadsheet with two tabs, tab one is the main results page and the other tab is the "tracking" page.
I have a dates column in the tracking page where the result is counted once a date is entered.
I have used this formula to report this through to the main page like this =COUNTIF('OTRs'!I5:I30,"<01/10/12")
My issue is the main tab I need to show these result for different quarters. 1st quarter 1July-30Sep, 2nd quarter 1Oct-31Dec and so on.
I have these results counting once a date is put in, but I now need to be able to put a formula in each quarter section so it will only pick up the dates for that particular quarter so somehow say "between 1Oct and 31 Dec" etc etc, in addition to my existing formula.
Hopefully this makes sense, I am terrible at explaining.
If anyone can help out that would be fantastic!