Intermediate · Lesson 9 of 12

Working with dates

Dates are numbers underneath

Excel stores each date as a count of days. That is why you can subtract one date from another to get the days between them.

Reading parts of a date

YEAR, MONTH and DAY each pull out one part.

Moving through the calendar

EDATE moves by whole months, EOMONTH finds the end of a month, and NETWORKDAYS counts working days.