| Functions in English | Functions in French | Description of Function |
|---|
| DATE | DATE | Returns the serial number of a particular date. |
| DATEDIF | DATEDIF | Calculates the number of days, months, or years between two dates. |
| 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. |