filmov
tv
How to use DATEVALUE Function in Excel | Excel Tips
Показать описание
How to use DATEVALUE Function in Excel | Excel Tips
DATEVALUE function in Excel converts a date that is stored as text to a serial number that Excel recognizes as a date. For example, the formula =DATEVALUE("1/1/2008") returns 39448, the serial number of the date 1/1/2008.
Syntax: DATEVALUE(date_text)
DATEVALUE function in Excel converts a date that is stored as text to a serial number that Excel recognizes as a date. For example, the formula =DATEVALUE("1/1/2008") returns 39448, the serial number of the date 1/1/2008.
Syntax: DATEVALUE(date_text)
0:03:14
0:03:47
0:02:16
0:04:19
0:06:42
0:03:07
0:04:10
0:04:52
0:01:39
0:02:10
0:04:04
0:00:34
0:04:59
0:01:19
0:02:26
0:11:46
0:01:38
0:00:34
0:00:22
0:02:28
0:01:31
0:01:53
0:00:25
0:00:21