Date and time functions

Functions in EnglishFunctions in FrenchDescription of Function
DATEDATEReturns the serial number of a particular date.
DATEVALUEDATEVALConverts a date in the form of text to a serial number.
DAYJOURConverts a serial number to a day of the month.
DAYSJOURSReturns the number of days between two dates (2013).
DAYS360JOURS360Calculates the number of days between two dates based on a 360-day year.
EDATEMOIS.DECALERReturns the serial number of the date that is the indicated number of months before or after the start date.
EOMONTHFIN.MOISReturns the serial number of the last day of the month before or after a specified number of months.
HOURHEUREConverts a serial number to an hour.
ISOWEEKNUMNO.SEMAINE.ISOReturns the number of the ISO week number of the year for a given date (2013).
MINUTEMINUTEConverts a serial number to a minute.
MONTHMOISConverts a serial number to a month.
NETWORKDAYSNB.JOURS.OUVRESReturns the number of whole workdays between two dates.
NETWORKDAYS.INTLNB.JOURS.OUVRES.INTLReturns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days.
NOWMAINTENANTReturns the serial number of the current date and time.
SECONDSECONDEConverts a serial number to a second.
TIMETEMPSReturns the serial number of a particular time.
TIMEVALUETEMPSVALConverts a time in the form of text to a serial number.
TODAYAUJOURDHUIReturns the serial number of today's date.
WEEKDAYJOURSEMConverts a serial number to a day of the week.
WEEKNUMNO.SEMAINEConverts a serial number to a number representing where the week falls numerically with a year.
WORKDAYSERIE.JOUR.OUVREReturns the serial number of the date before or after a specified number of workdays.
WORKDAY.INTLSERIE.JOUR.OUVRE.INTLReturns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days.
YEARANNEEConverts a serial number to a year.
YEARFRACFRACTION.ANNEEReturns the year fraction representing the number of whole days between start_date and end_date.