Duco_IT
asked on
Loan Laptop Database Using Excel 2007 - Identify late laptops and persistant offenders
Ive created a Loan Laptop spreadsheet in Excel that shows basically
I created formula that shows clearly when an item is overdue and has not been returned but.....
Is their a way so that if an item is overdue it adds that users name to another sheet and includes the number of days over due and the number of times its has been overdue from that user.
e.g. Fred has borrowed a laptop for 7 days, its now day 10 and it hasnt been returned. He has done this before but i cant see how many times. Id like the sheet to show that he has not returned the laptop X times to a total of X number of days. Built-PCs---Loan-Laptops.xlsx
who loaned the laptop
the from date
the to date
and if it has been returned
. I created formula that shows clearly when an item is overdue and has not been returned but.....
Is their a way so that if an item is overdue it adds that users name to another sheet and includes the number of days over due and the number of times its has been overdue from that user.
e.g. Fred has borrowed a laptop for 7 days, its now day 10 and it hasnt been returned. He has done this before but i cant see how many times. Id like the sheet to show that he has not returned the laptop X times to a total of X number of days. Built-PCs---Loan-Laptops.xlsx
Duco_IT,
As you are not recording when a laptop is returned it is not possible to analyse whether they were early, on time or late. At the very least you need a column to record the date on which a laptop is returned.
In fact the 'Returned' column should be used for that rather than recording only whether or not it has been returned. If there's a blank in the Returned column then by implication, the laptop has not been returned. If it has been returned then a date of return is needed.
Patrick
As you are not recording when a laptop is returned it is not possible to analyse whether they were early, on time or late. At the very least you need a column to record the date on which a laptop is returned.
In fact the 'Returned' column should be used for that rather than recording only whether or not it has been returned. If there's a blank in the Returned column then by implication, the laptop has not been returned. If it has been returned then a date of return is needed.
Patrick
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks loads for that
Duco_IT - Pleased it helped. Thanks for the grade. - Patrick
Built-PCs---Loan-Laptops.xlsx