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