Not sure what I need other than help

[SIU Jason]

I'm a student running a small school library. Currently we check out books
manually (read: non-electronically) by writing down a persons name, date,
book and due date. Then [sometimes] figure up their fees when the book
becomes overdue.

We do however have an excel sheet listing all of the books. I've added to
the excel sheet 3 columns, Student, Due Date, Fee.

What I want to do is generate a report that lists what books are overdue.
It sounds simple enough, but I cannot figure it out for the life of me.

I came up with this function: "=IF(Due_Date<Current_Date,Student)" and
copied that (and changed "Student" to "Fee", "Title", "Due_Date", etc where
applicable) into their respective columns on a seperate sheet. This gives me
what I want, but also gives me the negative response on the books that are
not overdue. Also, the "list" that it generates is a direct result of the
book list, ie: if book 1 and book 1300 are overdue, it shows those results on
lines 1 and 1300. This "list" is also not sortable, and I'm assuming that's
because the actual text of the IF statement doesn't change, so it does think
it's sorting it?

The end result that I'm looking for is a "list" that will tell me that ONLY
those books that are overdue, are overdue.

Is this possible?

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

 

[Eduardo]

Hi,
let's say you have the due date in column D then in column E enter

=IF(TODAY()-D2<=0,"","Overdue")

then sort column E by overdue

 

[Gary Brown]

- The formula calculating the fee should return either a 0 or a fee.
- Assume the Due date is in Column C and the Fees are in Column D
- The formula in column D should be something like...
=If(C2>Today(),0,(Today() - C2)*.05)
where .05 is the per day overdue fee
- Use the Autofilter (DATA > FILTER > AUTOFILTER) to create a filter
- Filter on the Fee column for > 0
- Now you have a report of only overdue fees

 

[L. Howard Kittle]

Hi SIU Jason,

I have written a student book check-out workbook for an inner school in
Manhattan, NY that does all of what you have asked. Actually one was for
text books and another was for library books.

For the library books:

That school has student ID cards and when they checked out a book they had
to swipe their card in a scanner and that student ID was recorded and then
scan in the book title BAR code. Now the student ID, the date, the book
name are all recorded. When the student returned the book, the student ID
and the book BAR code were also scanned in along with Date Returned and
number of days out.

At any time you may click on a Due List button and a list of any over due
book (based on 14 days) and the student and book are listed on a separate
sheet. (I included some formulas to assess what the fine would be for each
over due book based on the current daily overdue rate times the number of
days. The school was not interested in that but, whatever.)

You seem to not have a scanner and I would tell you I wrote the program
without a scanner by using phony student names and phony student ID numbers
which I manually typed in to simulate a scanner and when tested by the real
scan method it worked fine.

So manual entries of true data will work with my non-scan version.

If interested, you may e-mail me at (e-mail address removed) and I will send you
a copy. We can modify as needed to suit you.

Regards,
Howard

I'm a student running a small school library. Currently we check out
books
manually (read: non-electronically) by writing down a persons name, date,
book and due date. Then [sometimes] figure up their fees when the book
becomes overdue.

We do however have an excel sheet listing all of the books. I've added to
the excel sheet 3 columns, Student, Due Date, Fee.

What I want to do is generate a report that lists what books are overdue.
It sounds simple enough, but I cannot figure it out for the life of me.

I came up with this function: "=IF(Due_Date<Current_Date,Student)" and
copied that (and changed "Student" to "Fee", "Title", "Due_Date", etc
where
applicable) into their respective columns on a seperate sheet. This gives
me
what I want, but also gives me the negative response on the books that are
not overdue. Also, the "list" that it generates is a direct result of the
book list, ie: if book 1 and book 1300 are overdue, it shows those results
on
lines 1 and 1300. This "list" is also not sortable, and I'm assuming
that's
because the actual text of the IF statement doesn't change, so it does
think
it's sorting it?

The end result that I'm looking for is a "list" that will tell me that
ONLY
those books that are overdue, are overdue.

Is this possible?