Hi I seem to have a problem and I've spent the past couple of days trying to figure it out!!! (I thought my ALevel in IT might have come in use but obviously not)! LOL! It's not an easy one (unless of course you're an Excel geek)
Ok heres the problem:
Column B contains dates in the format of "DD-MMM-YY"
Column N contains ticks if the case is true: (the formula to generate: =IF(AND(B17 >= $G$5, B17 <= $G$6),"a","") - this generates the ticks i think usin a different font.
I need a formula which will: if the month between B17 to B200 = "Apr" (for example), then count the number of ticks in column N.
See I told you it wasn't straightforward Pleeeeaaassseee help if you know how! Thankkksssss in advance...
Ok heres the problem:
Column B contains dates in the format of "DD-MMM-YY"
Column N contains ticks if the case is true: (the formula to generate: =IF(AND(B17 >= $G$5, B17 <= $G$6),"a","") - this generates the ticks i think usin a different font.
I need a formula which will: if the month between B17 to B200 = "Apr" (for example), then count the number of ticks in column N.
See I told you it wasn't straightforward Pleeeeaaassseee help if you know how! Thankkksssss in advance...