# Date Time Functions - Date, Year, Month, Day, Time, Hour, Minute, Second, Today, Now, Datedif

**Date**

Returns a date, from a user-supplied year, month and day

> **=DATE(year, month, day)**

**Year**

Returns the year from a user-supplied date

> **=YEAR(serial\_number)**

**Month**

Returns the month from a user-supplied date

> **=MONTH(serial\_number)**

**Day**

Returns the day (of the month) from a user-supplied date

> **=DAY(serial\_number)**

**Time**

Returns a time, from a user-supplied hour, minute and second

> **=TIME(hour, minute, second)**

**Hour**

Returns the hour part of a user-supplied time

> **=HOUR(serial\_number)**

**Minute**

Returns the minute part of a user-supplied time

> **=MINUTE(serial\_number)**

**Second**

Returns the seconds part of a user-supplied time

> **=SECOND(serial\_number)**

**Today**

Returns today's date

> **=TODAY()**

**Now**

Returns the current date & time

> **=NOW()**

**DatedIf**

The Microsoft Excel DATEDIF function returns the difference between two date values, based on the interval specified.

The DATEDIF function is a built-in function in Excel that is categorized as a *Date/Time Function*. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the DATEDIF function can be entered as part of a formula in a cell of a worksheet.

> **=DATEDIF(start\_date, end\_date, return\_unit)**

![](https://2721809844-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LR_tHSREe3Wm40fY9NG%2F-LRuo0c0UE-RWI8YVqeC%2F-LRuoMFtUatHCuowL0p_%2Fimage.png?alt=media\&token=2f7f6c62-5f56-4c97-b74d-fec8b2c57bf6)

{% file src="<https://2721809844-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LR_tHSREe3Wm40fY9NG%2F-LRuo0c0UE-RWI8YVqeC%2F-LRupKGnMWhBHAQn-Dn1%2FDate-Time%20Function.xlsx?alt=media&token=d6d88ee8-d87b-488c-b6af-4e265ad1f014>" %}
Date-Time Formulas Examples
{% endfile %}