countif problem
 

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

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

"SLKPM" wrote:

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

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

SLKPM wrote:
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