Lab › Dates & Times
Dates & Times: Excel Lab
Ages, due dates, day names and late fees. Pick a lab. Watch how, then do it yourself.
LAB 18Beginner
Due Date and Day Name
Each invoice gives the customer some days to pay. Find the due date and the day of the week.
Date + days, TEXTOpen lab →
LAB 19Intermediate
Age from Date of Birth
Find each person's age in full years, as on 1 October 2026.
DATEDIF, $ absolute referenceOpen lab →
LAB 20Intermediate
Library Late Fee
Books returned after the due date pay 10 per day. Books returned early or on time pay nothing.
Date subtraction, MAX, $ absolute referenceOpen lab →
