Lab › Dates & Times › Due Date and Day Name
Due Date and Day Name: Excel Lab
Lab 18 · BeginnerDate + daysTEXT
The task: Each invoice gives the customer some days to pay. Find the due date and the day of the week.
1 Watch how it is done
Step 1: Due date = date + days
=B4+C4- Click D4.
- Type =B4+C4 and press Enter. Excel counts dates as days, so adding works.
- Drag the fill handle down.
Step 2: Day name
=TEXT(D4,"dddd")- Click E4.
- Type =TEXT(D4,"dddd") and press Enter.
- Drag the fill handle down.
2 Your turn
Download the practice file. It has new numbers. Open it in Excel (or Google Sheets) and do the same steps.
3 Check your answers
Stuck? Download the solution file and compare it with yours.
Next lab: Age from Date of Birth →
Want the theory? Read the Dates & Times lessons →
← More Dates & Times labs · All lab categories
