The first video discusses how dates and times are stored in spreadsheets. Dates and Times
There are functions to access the parts of Dates: MONTH(), DAY() and YEAR(). These functions are for Times: HOUR(), MINUTE() and SECOND(). Functions to manipulate Dates and Times
There are also some special functions to help manipulate Dates. Get dates for elapsed time, EDATE() and EOMONTH(). Find which day of the week a date is with WEEKDAY(), and find the week number during the year for a date with WEEKNUM(). Other Date Functions