E()

Read(2147) Label: excel date/time,

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:

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