---
title: Date and Time
slug: date-and-time
docTags: 
createdAt: 2025-09-22T04:53:54.000Z
---

### DATE

**Description: **Returns the sequential serial number that represents a particular date.

**Example: **

*DATE(year, month, day)*

### DATEDIFF

**Description: **Returns a formatted summary of difference between two dates.

**Example: **

*DATEDIFF(start\_date, end\_date)*

### DATETIMENOW

**Description: **Returns the current date and time in date/time format

**Example: **

*DATETIMENOW( )*

### DATEVALUE

**Description: **Returns the serial number of the date value.

**Example: **

*DATEVALUE(date\_text)*

### DAY

**Description: **Returns the day of the month.

**Example: **

*DAY(serial\_number)*

### DAYS360

**Description: **Returns the number of days between two dates using 360-day year.

**Example: **

*DAYS360(start\_date, end\_date, method)*

### HOUR

**Description: **Returns the hour from 0 to 23.

**Example: **

*HOUR(serial\_number)*

### MINUTE

**Description: **Returns the minute from 0 to 59.

**Example: **

*MINUTE(serial\_number)*

### MONTH

**Description: **Returns the month from 1 to 12.

**Example: **

*MONTH(serial\_number)*

### NETWORKDAYS

**Description: **Calculates the number of whole work days between two given dates. This includes all weekdays from Monday to Friday, but excludes a supplied list of holidays

**Example: **

*NETWORKDAYS(start\_date, end\_date, \[holidays])*

### NETWORKDAYSWITHOFFSET

**Description: **Calculates the number of whole work days between two given dates with a specified time offset relative to Coordinated Universal Time (UTC). This includes all weekdays from Monday to Friday, but excludes a supplied list of holidays. The offset and holidays arguments cannot be provided as field references.

**Example: **

*NETWORKDAYSWITHOFFSET(start\_date, end\_date, "-06*:00*", "7/4/2025,12/25/2025,1/1/2026")*

### NOW

**Description: **Returns the current date and time.

**Example: **

*NOW( )*

### NOW

**Description: **Returns the current date and time.

**Example: **

*NOW( )*

### SECOND

**Description: **Returns the second from 0 to 59.

**Example: **

*SECOND(serial\_number)*

### TIME

**Description: **Returns serial number time.

**Example: **

*TIME(hour, minute, second)*

### TIMEVALUE

**Description: **Returns the serial number time from a string.

**Example: **

*TIMEVALUE(time\_text)*

### TODAY

**Description: **Returns the current date.

**Example: **

*TODAY( )*

### TOTALDAYS

**Description: **Returns the total number of days between two dates

**Example: **

*TOTALDAYS(start\_date, end\_date)*

### TOTALHOURS

**Description: **Returns the total number of hours between two dates

**Example: **

*TOTALHOURS(start\_date, end\_date)*

### TOTALMINUTES

**Description: **Returns the total number of minutes between two dates

**Example: **

*TOTALMINUTES(start\_date, end\_date)*

### WEEKDAY

**Description: **Returns the weekday from 1 to 7.

**Example: **

*WEEKDAY(serial\_number,return\_type)*

### YEAR

**Description: **Returns the year from 1900 to 9999.

**Example: **

*YEAR(serial\_number)*