The file that you linked to did indeed look like the results I was getting
(including the 38504 date code and the numbers in the rows that were the
resulting rows that were specified for Sheet2 A1).

On Sheet2, in A1, is there a way to specific a date range (say from
17-Jun-05 to 04-Jul-05)?

--
Thanks,
Diane


"Max" wrote:

---This is the column on Sheet1 where you told me to put in the coding.
... so I had to adjust your instructions one column over.
So I actually have Subject, Name, What, StartDate, Deadline
as my colunn headings in row 1.

Thanks for clarifying. If you had adjusted correctly earlier, then what's
described for col E will apply to col F. And the formula meant to be in F1
should now reside in G1 instead. F1 should now be left empty. And the
formulas in Sheet2 should now point to col F instead of col E, etc. Guess
I'm not really sure from your earlier comments whether the F1 to G1, and the
F1 left empty adjustment parts, etc were correctly done. In any case, think
the sample file provided ought to have clarified the suggested construct
sufficiently for any further adaptations to be done.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----