filmov
tv
Excel NETWORKDAYS function not working
Показать описание
00:00 NETWORKDAYS function not working
00:07 Start dates or End dates not seen as dates by Excel
00:53 Excel confusing the 2 digit year with the month or day
01:25 Format the cells to show the date
02:01 The 'number' Excel sees as the date is too big
02:25 Holiday list in NETWORKDAYS must be valid Excel dates
The reasons, in priority order, why Excel's NETWORKDAYS function may not be working.
00:07 Start dates or End dates not seen as dates by Excel
00:53 Excel confusing the 2 digit year with the month or day
01:25 Format the cells to show the date
02:01 The 'number' Excel sees as the date is too big
02:25 Holiday list in NETWORKDAYS must be valid Excel dates
The reasons, in priority order, why Excel's NETWORKDAYS function may not be working.
0:03:01
0:03:02
0:07:25
0:03:04
0:04:18
0:01:47
0:00:37
0:00:16
0:10:09
0:00:20
0:00:33
0:00:14
0:03:03
0:00:35
0:01:03
0:04:04
0:02:48
0:00:40
0:01:00
0:00:25
0:00:47
0:00:15
0:07:53
0:00:20