hi,
Im trying to calculate the number of people that signed up to a website each day by counting the number of times a date appears.
the formula im using is:
=COUNTIF(T$2:T$1782, V2) - V2 is the cell with the date and the range is the dates i want to count.
For some days it counts it correctly, but most it doesnt count them at all. Ive formatted the cells as date and made sure they are the same format as the cells im counting.
The other thing i tried was:
=COUNTIF(T$2:T$1782, "01/01/08") which seems to work fine but is there a way i can copy the formula without having to type it in for each day?
thanks
Im trying to calculate the number of people that signed up to a website each day by counting the number of times a date appears.
the formula im using is:
=COUNTIF(T$2:T$1782, V2) - V2 is the cell with the date and the range is the dates i want to count.
For some days it counts it correctly, but most it doesnt count them at all. Ive formatted the cells as date and made sure they are the same format as the cells im counting.
The other thing i tried was:
=COUNTIF(T$2:T$1782, "01/01/08") which seems to work fine but is there a way i can copy the formula without having to type it in for each day?
thanks