countif problem

[Guest]

I have a worksheet set up with numerous dates assigned to each column, these
dates can be up to 16 months in advance. How do I set it up using a function
to calculate the number of occurences between for example; today and 7 days
time in each particular column to give a total at the bottom.

Any help would be great as i'm now scratching my head on this one...Many
thanks,

SLKPM

 

[Guest]

=SUMPRODUCT(--(A1:A200>=TODAY()),--(A1:A200<=(TODAY()+7)))

 

[Aladin Akyurek]

=COUNTIF(DateRange,">="&TODAY())-COUNTIF(DateRange,">"&TODAY()+7)