Funkcije datuma i vremena
Posljednja promjena 24.07.2005
| Date & Time | ||||
| Name | Source | Type | Description | Syntax |
| DATE | Built In | Date & Time | Returns the sequential Excel date / time serial number that represents a particular date | =DATE(year,month,day) |
| DATEDIF | Analysis ToolPak | Date & Time | Calculates differences between two dates in terms of specified units and assumptions | =DATEDIF(start_date,end_date,unit) |
| DATEVALUE | Built In | Date & Time | Converts a date text form to an Excel date / time serial number | =DATEVALUE(date_text) |
| DAY | Built In | Date & Time | Converts an Excel date / time serial number to the day of a month | =DAY(serial_number) |
| DAYS360 | Built In | Date & Time | Calculates the number of days between two dates using a specified 30 day month 360 day year method | =DAYS360(start_date,end_date,method) |
| EDATE | Analysis ToolPak | Date & Time | Returns the Excel date / time serial number of the date that is the indicated number of months before or after the specified number of months from the start_date | =EDATE(start_date,months) |
| EOMONTH | Analysis ToolPak | Date & Time | Returns the Excel date / time serial number of the last day of the month before or after a specified number of months from start_date | =EOMONTH(start_date,months) |
| HOUR | Built In | Date & Time | Converts an Excel date / time serial number to an hour | =HOUR(serial_number) |
| MINUTE | Built In | Date & Time | Converts an Excel date / time serial number to a minute | =MINUTE(serial_number) |
| MONTH | Built In | Date & Time | Converts an Excel date / time serial number to a month number | =MONTH(serial_number) |
| NETWORKDAYS | Analysis ToolPak | Date & Time | Returns the number of whole working days between two dates excluding specified holidays | =NETWORKDAYS(start_date,end_date, holidays) |
| NOW | Built In | Date & Time | Returns the Excel date / time serial number of the current date and time | =NOW() |
| SECOND | Built In | Date & Time | Converts an Excel date / time serial number to a second | =SECOND(serial_number) |
| TIME | Built In | Date & Time | Returns the decimal portion of an Excel date / time serial number for a particular time | =TIME(hour,minute,second) |
| TIMEVALUE | Built In | Date & Time | Converts the time in an acceptable form of text enclosed in quotation marks to the decimal portion of an Excel date / time serial number | =TIMEVALUE(time_text) |
| TODAY | Built In | Date & Time | Returns the Excel date / time serial number of today’s date | =TODAY() |
| WEEKDAY | Built In | Date & Time | Converts an Excel date / time serial number to the number of the day of the week based upon counting system of return_type | =WEEKDAY(serial_number,return_type) |
| WEEKNUM | Analysis ToolPak | Date & Time | Returns the weeknumber in the year based upon return_type counting basis | =WEEKNUM(serial_num,return_type) |
| WORKDAY | Analysis ToolPak | Date & Time | Returns the Excel date / time serial number of the date before or after a specified number of workdays excluding holidays | =WORKDAY(start_date,days,holidays) |
| YEAR | Built In | Date & Time | Converts an Excel date / time serial number to a year | =YEAR(serial_number) |
| YEARFRAC | Analysis ToolPak | Date & Time | Returns the difference between start_date and end_date expressed as a number of years including decimal fraction of a year. | =YEARFRAC(start_date,end_date,basis) |