Assuming you have your dates in ColA. Try the below formula. If tried today
this will give you the count of dates from 04/30/09 to 05/06/09 both
inclusive.. You can adjust to suit your requirement


=COUNTIF(A:A,"<" & TODAY()+8)-COUNTIF(A:A,"<" & TODAY()+1)

If this post helps click Yes
---------------
Jacob Skaria


"Louisa" wrote:

I have a worksheet with a list of arrival dates. I need to count how many of
these dates fall within the next seven days. This calculation would need to
be self-updating on a daily basis. Is this possible?