Function

Purpose

Example

Result

WEEKDAY

The weekday of a date number

Text (WeekDay(44694))

6

YEARDAY

The year day of a date number

Text (YearDay(44694))

133

YEARWEEK

The week of a date number

Text (Yearweek(44694))

19

DAY

The day of a date number

Text (Day(44694))

13

MONTH

The month of a date number

Text (Month(44694))

5

YEAR

The year of a date number

Text (Year(44694))

2022

REALTODATE

The textual notation of a date number

Text (RealToDate(44694))

13-5-2022

REALTODATETIME

The textual notation of a date number

Text (RealToDateTime(44694.345))

13-5-2022 08:16:48

DATETOREAL

The date number of a textual date

Text (DateToReal('13-5-2022'))

44694

DATETIMETOREAL

The date time number of a textual date

Text (DateTimeToReal('13-5-2022 9:34'))

44694.3986111111