Fonctions Date et heure
[ ] indicates optional parameters
ANNEE(numéro_de_série)Returns the year number (greater than or equal to 1900) from the specified date/time value.
numéro_de_série | The date/time value from which you want to extract the year number. |
Returns the serial number corresponding to the current date.
Returns the date value corresponding to a specified year, month and day. Note that only dates from 1900 onwards can be used.
année | The year number. If you enter a number less than 1900 then 1900 will be added to the value. |
mois | The month number. Preferably between 1 and 12. |
jour | The day number. Preferably between 1 and 31. |
Returns the difference between two dates in the units that you specify.
date1 | The 'from' date. | ||||||||||||
date2 | The 'to' date. This should be greater than or equal to the 'from' date. | ||||||||||||
units | The units in which you want the difference expressed. The possible values are: | ||||||||||||
|
Returns the date value that corresponds to a date in text form. Note that only dates from 1900 onwards can be used. You should not need to use this function, as dates are automatically converted from text to date values when they are used in formulas.
date_texte | The date that you want to convert. It can contain date separators and/or a month name. If only the day and month is supplied then the year will default to the current year. |
Returns the date that is the last day of the month calculated from the start date plus or minus a number of months.
start_date | The 'from' date. |
months | The number of months to be added or subtracted. |
FRACTION.ANNEE(start_date; end_date; [basis])
Returns the fraction of a year represented by the difference between two dates.
start_date | The 'from' date. | ||||||||||
end_date | The 'to' date. | ||||||||||
basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
If this parameter is omitted it defaults to 0. |
Returns the hour number (between 0 and 23) from the specified date/time value.
numéro_de_série | The date/time value from which you want to extract the hour number. |
Returns the day number (between 1 and 31) from the specified date value.
numéro_de_série | The date value from which you want to extract the day number. |
JOURS360(date_début; date_fin; [méthode])
Returns the number of days between two dates using a 360-day year (30 day months).
date_début | The 'from' date. | ||||
date_fin | The 'to' date. | ||||
méthode | Indicates how to deal with end dates that are the 31st of the month (the start date will always be moved from the 31st to the 30th). The options are: | ||||
| |||||
If this parameter is omitted it defaults to FAUX. |
JOURSEM(numéro_de_série; [type_retour])
Returns a number representing the day of the week of a given date.
numéro_de_série | The date/time value from which you want the day of the week. | ||||||
type_retour | The range of values returned and what they represent. The possible values are: | ||||||
| |||||||
If this parameter is omitted it defaults to 1. |
Returns the serial number corresponding to the current date and time.
Returns the minute number (between 0 and 59) from the specified date/time value.
numéro_de_série | The date/time value from which you want to extract the minute number. |
Returns the month number (between 1 and 12) from the specified date/time value.
numéro_de_série | The date/time value from which you want to extract the month number. |
MOIS.DECALER(start_date; months)
Returns the date that is the start date plus or minus a number of months.
start_date | The 'from' date. |
months | The number of months to be added or subtracted. |
NB.JOURS.OUVRES(start_date; end_date; [holidays])
Returns the number of working days (weekdays) between the start and end dates, excluding any holidays.
start_date | The 'from' date. |
end_date | The 'to' date. |
holidays | A date or array of dates or a reference to a list of dates that are to be treated as non-working days. |
NO.SEMAINE(numéro_de_série; [return_type])
Returns the week of the year of a given date.
numéro_de_série | The date/time value from which you want the week number. | ||||||
return_type | The method used to calculate the week number. The possible values are: | ||||||
| |||||||
If this parameter is omitted it defaults to 1. |
Returns the second number (between 0 and 59) from the specified date/time value.
numéro_de_série | The date/time value from which you want to extract the second number. |
SERIE.JOUR.OUVRE(start_date; number_days; [holidays])
Returns the working day that is the start date plus or minus a number of working days (weekdays), excluding any holidays.
start_date | The 'from' date. |
number_days | The number of working days to add or subtract. |
holidays | A date or array of dates or a reference to a list of dates that are to be treated as non-working days. |
Returns the serial number corresponding to a specified hour, minute and second.
heure | The hour number. Preferably between 0 and 23. |
minute | The minute number. Preferably between 0 and 59. |
seconde | The second number. Preferably between 0 and 59. |
Returns the time value that corresponds to a time in text form. You should not need to use this function, as times are automatically converted from text to time values when they are used in formulas.
heure_texte | The time that you want to convert. It can contain time separators and/or AM/PM designators. If seconds or minutes and seconds are not specified then they will default to zero. |