Description:
Switch between an Excel date/time value and a numeric value.
Syntax:
E(x)
Note:
Treat parameter x as a date/time/datetime value according to Excel rules when it is a numeric value, and convert it to a numeric value when it is a date/time/datetime value.
Parameter:
|
x |
A numeric/date/time value |
Return value:
A numeric/date/time value
Example:
|
|
A |
|
|
1 |
=E(3) |
1900-01-03 |
|
2 |
=E(3.5) |
1900-01-03 12:00:00 |
|
3 |
=E(date("1900-01-02 01:04:45")) |
2 |
|
4 |
=E(datetime("1900-01-01 12:43:01")) |
1.5298726851851852 |