I am a nurse and I have to track 90 patients that need to have an assessment
done on a quarterly basis. I have added their room number, name, and date of
last assessment in a excel workbook. The patients are located on three
different units so I created a worksheet for each unit.

The worksheets have a row for each patient, with the following columns:
A=Room Number; B=Name; C=Date; D=Score; E=Next Due Date. Column E is a
calculated field that is "=C+90. Yes, this formula has the appropriate row
number.

In a fourth worksheet, I would like to create a report that gives me a list
of patients that would be due within a certain date range that I enter into a
field. I have no idea how to do this.

Thanks in advance for any help you can provide.