Question: i need formula for Due date, and days overdue using EXCEL i need formula for Due date, and days overdue using EXCEL The following is

i need formula for Due date, and days overdue using EXCEL

i need formula for Due date, and days overdue using EXCEL i

i need formula for Due date, and days overdue using EXCEL

The following is a list of people who have borrowed books from the library. There is a column for check-out date and a column for due-date. In the 3rd column, please calculate days overdue. If a book is NOT overdue, this column should reflect the number zero. Books are checked out for a total of 14 days. Calculate the due date based on the check-out date. Place it in the due-date column. If the book is overdue, this column should reflect a positive number which is the days overdue as of 1/28/2020 In the "Alert" column, place the word "overdue" if the person's book is overdue. Format the Headers and Underline them so they will not be confused with the data. Days Overdue Alert Person Addie Joss Al Barlick Al Kaline Al Lpez Al Simmons Al Spalding Alan Trammell Alex Pompez Alexander Cartwright Amos Rusie Andre Dawson Book Check-out Date Due Date Lucky Jim by Kingsley Amis 1/27/2020 Money by Martin Amis 1/11/2020 The Information by Martin Amis 1/19/2020 The Bottle Factory Outing by Beryl Bainbridge 1/10/2020 According to Queeney by Beryl Bainbridge 1/3/2020 Flaubert's Parrot by Julian Barnes 1/26/2020 A History of the World in 10 1/2 Chapters by Julian Barnes 1/26/2020 Augustus Carp, Esq. by Himself: Being the Autobiography of a Really Good Man by Hen 1/28/2020 Molloy by Samuel Beckett 12/31/2019 Zuleika Dobson by Max Beerbohm 1/24/2020 The Adventures of Augie March by Saul Bellow 1/20/2020

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!