Cathal,,

I don't know where your dates are, but let's say they are in A1:R20, then
in S19, add

=COUNTIF(A1:R20,"<="&S18-7)

I was suggesting you don't bother with a pop-up, but just tell the user to
put a date in S18, the formula will then automatically count the number.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"CPower " wrote in message
...
Bob i think this would be more suitable, but how do i get a pop up
asking the user to enter the date in cell e.g. S18, in the format
mm/dd/yyyy, then to enter the amount of rows, with dates before e.g.
05/30/2004, into cell S19???

Thanks a mil for this help.
Cathal.


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