Trying to Use All 25 Date Functions in One Spreadsheet

preview_player
Показать описание
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.

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
Рекомендации по теме
Комментарии
Автор

Hi there, how can I get the number of the week within the month, not a year.

Weeknum provides the number of weeks within the year. I just need something within the month, so it would only display values 1 up to 5

Thanks!

perezmingi