Task 1 of 6
In D2:D6, calculate the date the book is due back: the checkout date plus the loan period in days.
Lesson theory
A public library keeps track of the books it has loaned out. Practice adding to dates, IF with dates, WEEKDAY, NETWORKDAYS, EOMONTH and calculating hours.
Tip: a date is a day number, so "in 14 days" is simply =B2+14, and the difference between two dates is a subtraction.
Practice is part of Pro
The live spreadsheet, task checking and .xlsx files in all 170 lessons. Your progress is saved in this browser; sync across devices is coming soon.