Hi,

or, if you don't want to create a new column, try this:

=SUM(COUNTIF(A1:A11,TODAY()+7),COUNTIF(A1:A11,TODAY()+8),COUNTIF(A1:A11,TODAY()+9))
(obviously put whatever range you use in)

The draw back with this is that you would need to extend it all the way to +28.

Possibly to long for the specific use you have in mind, but worth bearing in mind for the future. The biggest one of these i have ever used had 15 countif's in. They are actually really easy to construct as all you have to do is copy and paste ",COUNTIF(A1:A11,TODAY()+8)" however many times you want and then just work back through changing the number on the end.

Like i said, the main advanteage here is that you don't have to have any hidden columns

Later

Matt