BBampaa

Lessons › Excel & Google Sheets

Excel & Google Sheets lesson

Dates

Delivered minus ordered: 3 days.

Try this lesson free →
About 5–10 minutes · no sign-up needed

Example

Spreadsheets store dates as numbers, so you can subtract them:

=C2-B2

Typed into cell D2 of this sheet:

OrderOrderedDeliveredDaysWeekday
O101{'date': '2024-03-01'}{'date': '2024-03-04'}
O102{'date': '2024-03-04'}{'date': '2024-03-08'}
O103{'date': '2024-03-05'}{'date': '2024-03-06'}
O104{'date': '2024-03-07'}{'date': '2024-03-14'}
O105{'date': '2024-03-11'}{'date': '2024-03-13'}

Key points

C2-B2Later date minus earlier date gives the days between.
TEXT(B2,"dddd")Turns a date into its weekday name.
MONTH(B2)Pulls out the month number. YEAR and DAY work the same way.

=DAYS(C2,B2) also counts the days between, with the later date first.

Practice

Try each one in your head first, then open the answer.

1. In D3, work out how many days order O102 took.
=C3-B3
2. In E2, show which weekday order O101 was placed.
=TEXT(B2,"dddd")
3. In D4, work out how many days order O103 took.
=C4-B4
4. In E3, show the weekday order O102 was placed.
=TEXT(B3,"dddd")
5. In D6, work out how many days order O105 took, using the DAYS function.
=DAYS(C6,B6)

Learn it by doing. This lesson is a short hands-on level on Bampaa: see it work, then build and write it yourself, with instant feedback.

Try this lesson free →
About 5–10 minutes · no sign-up needed