Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems For Advanced Applications 18th International Conference Dasfaa 2013 Wuhan China April 22 25 2013 Proceedings Part 2 Lncs 7826

Authors: Weiyi Meng ,Ling Feng ,Stephane Bressan ,Werner Winiwarter ,Wei Song

2013th Edition

3642374492, 978-3642374494

More Books

Students also viewed these Databases questions

Question

Why is it important to write with the audience in mind?

Answered: 1 week ago

Question

2. Are you varying your pitch (to avoid being monotonous)?

Answered: 1 week ago

Question

3. Are you varying your speaking rate and volume?

Answered: 1 week ago