Countif - recognition problems with dates

S

simoncottle

=COUNTIF(Pitches!$C$15:$C$67,"<=Pitches!B5+3")

Im trying to get countif to recognise dates that are less than thre
days away. B5 is todays date..

Any suggestions on where I am going wrong
 
S

simoncottle

Thanks

As an add onto this does anyone know how to use countif with multiple
criteria

I have dates of projects that are attached to names, but i want to be
able to count only those projects at today +3 that are attached to
certain names.

At the moment i can count those with deadlines in the next three days
but not attach those to names.

I've tried being clever by separating out another table with the dates
attached to new names, but this isnt working properly and isnt a neat
solution

Thanks Simon
 
T

Toppers

TRY:

=SUMPRODUCT(--(Pitches!C15:C67<=Pitches!B5+3),--(D15:D67=<name>))

Replace <name> with name e.g. "Fred" or cell reference containing name
 
Top