Below is the list of 24 Date and Time functions, please see below for details or check all Excel functions here:
| Function | Formula |
|---|---|
| DATE Function | Date(Year,Month,Day) |
| DATEDIF Function | Datedif(Start_Date,End_Date,Unit) |
| DATEVALUE Function | Datevalue(Date_Text) |
| DAY Function | Day(Serial_Num) |
| DAYS360 Function | Days360(Start,End,[Method]) |
| EDATE Function | Edate(Start_Date, Months) |
| EOMONTH Function | Eomonth(Start_Date, Months) |
| HOUR Function | Hour(Serial_Num) |
| ISOWEEKNUM Function | Isoweeknum(Date) |
| MINUTE Function | Minute(Serial_Num) |
| MONTH Function | Month(Serial_Num) |
| NETWORKDAYS Function | Networkdays(Start_Date, End_Date, [Holidays]) |
| NETWORKDAYS.INTL Function | Networkdays.Intl(Start, End, [Weekend], [Holidays]) |
| NOW Function | Now() |
| SECOND Function | Second(Serial_Num) |
| TIME Function | Time(Hour, Minute, Second) |
| TIMEVALUE Function | Timevalue(Time_Text) |
| TODAY Function | Today() |
| WEEKDAY Function | Weekday(Serial_Num,[Return_Type]) |
| WEEKNUM Function | Weeknum(Serial_Num,[Return_Type]) |
| WORKDAY Function | Workday(Start_Date, Days, [Holidays]) |
| WORKDAY.INTL Function | Workday.Intl(Start_Date, Days, [Weekend], [Holidays]) |
| YEAR Function | Year(Serial_Num) |
| YEARFRAC Function | Yearfrac(Start_Date, End_Date, [Basis]) |