Functions in English | Functions in French | Description of Function |
---|
DATE | DATE | Returns the serial number of a particular date. |
DATEVALUE | DATEVAL | Converts a date in the form of text to a serial number. |
DAY | JOUR | Converts a serial number to a day of the month. |
DAYS | JOURS | Returns the number of days between two dates (2013). |
DAYS360 | JOURS360 | Calculates the number of days between two dates based on a 360-day year. |
EDATE | MOIS.DECALER | Returns the serial number of the date that is the indicated number of months before or after the start date. |
EOMONTH | FIN.MOIS | Returns the serial number of the last day of the month before or after a specified number of months. |
HOUR | HEURE | Converts a serial number to an hour. |
ISOWEEKNUM | NO.SEMAINE.ISO | Returns the number of the ISO week number of the year for a given date (2013). |
MINUTE | MINUTE | Converts a serial number to a minute. |
MONTH | MOIS | Converts a serial number to a month. |
NETWORKDAYS | NB.JOURS.OUVRES | Returns the number of whole workdays between two dates. |
Functions in English | Functions in French | Description of Function |
---|
NETWORKDAYS.INTL | NB.JOURS.OUVRES.INTL | Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days. |
NOW | MAINTENANT | Returns the serial number of the current date and time. |
SECOND | SECONDE | Converts a serial number to a second. |
TIME | TEMPS | Returns the serial number of a particular time. |
TIMEVALUE | TEMPSVAL | Converts a time in the form of text to a serial number. |
TODAY | AUJOURDHUI | Returns the serial number of today's date. |
WEEKDAY | JOURSEM | Converts a serial number to a day of the week. |
WEEKNUM | NO.SEMAINE | Converts a serial number to a number representing where the week falls numerically with a year. |
WORKDAY | SERIE.JOUR.OUVRE | Returns the serial number of the date before or after a specified number of workdays. |
WORKDAY.INTL | SERIE.JOUR.OUVRE.INTL | Returns 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. |
YEAR | ANNEE | Converts a serial number to a year. |
YEARFRAC | FRACTION.ANNEE | Returns the year fraction representing the number of whole days between start_date and end_date. |