Trying to Use All 25 Date Functions in One Spreadsheet
This video will teach you about the date and time functions available in Google Sheets and Microsoft Excel. Learning them will help you work more efficiently in your own spreadsheets.
Link to the spreadsheet: https://bit.ly/25-date-functions
Categorized list of date and time functions: https://sheetshelp.com/types-of-date-...
Timestamps:
0:00 Intro
0:48 DATE and DAYS
1:50 ISDATE
5:24 YEARFARC
6:58 DATEDIF
10:25 YEAR, MONTH, DATE, HOUR, MINUTE, and SECOND
13:15 TIME
14:19 DATEVALUE and TIMEVALUE
18:05 EDATE
19:20 EOMONTH
20:18 TODAY
22:03 NETWORKDAYS, NETWORKDAYS.INTL, and NOW
24:07 WORKDAY and WORKDAY.INTL
26:49 WEEKNUM and ISOWEEKNUM
28:11 WEEKDAY
29:40 DAYS360
#spreadsheet #googlesheets #excel