Unit 9 of 12 Lesson 1 free · Plus

Dates and time

Deadlines, durations, and calendars.

Key ideas

=B2+30

Excel counts days, so adding 30 to a date moves it 30 days later.

=YEAR(B2)

YEAR, MONTH and DAY return pieces of a date as plain numbers.

=EOMONTH(B2,0)

EOMONTH finds the last day of a month. NETWORKDAYS counts weekdays between two dates.

How does Excel store a date like Jan 5, 2026?
- As a number counting days
- As text
- As three separate numbers
- As a picture
Show answer
As a number counting days. That is why you can add and subtract dates.
Ship date is the order date plus the days to ship. Write it in D2 so it fills down to D6.
A B C D
1 Order Ordered Days to ship Ships
2 A-100 2026-01-05 3
3 A-101 2026-01-12 7
4 A-102 2026-02-03 2
5 A-103 2026-02-20 10
6 A-104 2026-03-09 5
Hint: =B2+C2
Show answer
=B2+C2 in D2. Adding days to a date gives a new date.
What will A1 show?
A
1
A1 contains =DATE(2026,3,15)
Show answer
Mar 15, 2026. DATE builds a date from year, month and day.
Pull the year out of each order date. Start in D2 and fill to D6.
A B C D
1 Order Ordered Days to ship Year
2 A-100 2026-01-05 3
3 A-101 2026-01-12 7
4 A-102 2026-02-03 2
5 A-103 2026-02-20 10
6 A-104 2026-03-09 5
Hint: =YEAR(B2)
Show answer
=YEAR(B2) in D2. YEAR returns a plain number you can group or filter by.
Build: the month number of the date in B2
Show answer
=MONTH(B2). MONTH returns 1 to 12.

	A
1

Lesson 2 is part of Cellwise Plus. Lesson 1 above is free to read here and to practice in the app.

Lesson 3 is part of Cellwise Plus. Lesson 1 above is free to read here and to practice in the app.