Datumové funkce

Top  Previous  Next

Seznam témat:

popis funkce

 

Popis funkce

Datumové a časové funkce:

DATE

year, month and day        

=DATE(1900,1,1)

Calculates the serial number that represents a specified date

DAY

=DAY(TODAY())

Returns the day portion of a given date

HOUR

=HOUR(NOW())

Returns the hour portion of a given date/time value

MONTH

=MONTH(TODAY())

Returns the month portion of a given date

MINUTE

=MINUTE(NOW())

Returns the minutes portion of a given date/time value.

NOW

=NOW()

Returns the current time in general format.  You can apply further formatting to the result of the function

SECOND

=SECOND(NOW())

Returns the seconds portion of a given date/time value

TIME

=TIME(16, 48, 10)

Returns the serial number of the current date

TODAY

=TODAY()

Two arguments: the serial number of the required date, weekday base

WEEKDAY        

=WEEKDAY(TODAY())

=WEEKDAY(DATE( 2002; 12; 1);1)

returns 1(Sunday)

Returns the day of the week corresponding to the specified date.The weekday base identifies the first day of the week and determines the return value type:1 or omitted: the first day of the week is Sunday.  The function returns 1 for Sunday, 2 for Monday, etc.2: the first day of the week is Monday.  The function returns 1 for Monday, 2 for Tuesday, etc.3: the first day of the week is Monday.  The function returns 0 for Monday, 1 for Tuesday, etc.

YEAR

=YEAR(TODAY())        

One argument defining the serial number of the required date. Returns the year portion of a given date.

 

Související témata

Matematické funkce

Statistické funkce

Logické funkce

Stringové funkce

Formátovací funkce