Hi all, I'm so confused.

I have a 2 sheet worksheet. Sheet 1 contains data based on the documen
information and the date they were received (Each document is entere
in a new row and therefore, the same date is usually entered more tha
once), Sheet 2 contains a weekly report.

In Sheet 2, I need to count the total number of documents receive
between a specified period.

eg: Sheet 1, column A, will have dates ranging from 01/01/04 t
01/07/04 (dd/mm/yy) and I only want to count the number of document
received between 01/05/04 & 05/05/04.

Any suggestions would be greatly appreciated.

Thanks heaps

--
Message posted from http://www.ExcelForum.com