Important Date functions

DATE : Date function take three arguments namely Year, Month and day and returns a valid excel date as number

DATEDIF : Returns the number of years, months and days between two dates

DATEVALUE : Converts a date in text format and returns a valid date as serial number.

DAY : This function returns the day of the month as a number from 1 to 31 from a date input

EDATE : Returns a date as serial number adding a number of months after or before a specified date excluding weekends (Saturday and Sunday) and holidays.

EOMONTH : Returns the last date of the month after adding or subtracting number of months from a given date

HOUR : Returns the hour of the time as integer from 0 to 23.

MINUTE : Returns the minute of the time as integer from 0 to 59

MONTH : Returns the month of the date as integer from 1 to 12

NETWORKDAYS : Returns the number of workdays between two dates excluding the weekends and holidays

NOW : Returns the current date and time.

SECOND : Returns the seconds value of the time as integer from 0 to 59

TIME : Returns a valid time by taking three inputs namely Hour, Minute and second

TIMEVALUE : Converts a time in text format and returns a valid time as serial number

TODAY : Returns the current system date

WEEKDAY : Returns a number between 1 to 7 representing the seven days of a week based on the supplied date

WORKDAY : Returns a date as serial number adding a number of days after or before a specified date excluding weekends

YEAR : This function returns the year part of a date as a number.