Дата и время functions
[ ] indicates optional parameters
ВРЕМЗНАЧ(время_как_текст)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.
| время_как_текст | 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. |
Returns the serial number corresponding to a specified hour, minute and second.
| час | The hour number. Preferably between 0 and 23. |
| минута | The minute number. Preferably between 0 and 59. |
| секунда | The second number. Preferably between 0 and 59. |
Returns the year number (greater than or equal to 1900) from the specified date/time value.
| дата_как_число | The date/time value from which you want to extract the year number. |
Returns the date value corresponding to a specified year, month and day. Note that only dates from 1900 onwards can be used.
| год | The year number. If you enter a number less than 1900 then 1900 will be added to the value. |
| месяц | The month number. Preferably between 1 and 12. |
| день | The day number. Preferably between 1 and 31. |
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.
| дата_как_текст | 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 start date plus or minus a number of months.
| начальная_дата | The 'from' date. |
| месяцев | The number of months to be added or subtracted. |
Returns the day number (between 1 and 31) from the specified date value.
| дата_как_число | The date value from which you want to extract the day number. |
ДЕНЬНЕД(дата_как_число, [тип])
Returns a number representing the day of the week of a given date.
| дата_как_число | The date/time value from which you want the day of the week. | ||||||
| тип | The range of values returned and what they represent. The possible values are: | ||||||
| |||||||
| If this parameter is omitted it defaults to 1. |
ДНЕЙ360(начальная_дата, конечная_дата, [метод])
Returns the number of days between two dates using a 360-day year (30 day months).
| начальная_дата | The 'from' date. | ||||
| конечная_дата | The 'to' date. | ||||
| метод | 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 ЛОЖЬ. |
ДОЛЯГОДА(начальная_дата, конечная_дата, [basis])
Returns the fraction of a year represented by the difference between two dates.
| начальная_дата | The 'from' 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 date that is the last day of the month calculated from the start date plus or minus a number of months.
| начальная_дата | The 'from' date. |
| месяцев | The number of months to be added or subtracted. |
Returns the month number (between 1 and 12) from the specified date/time value.
| дата_как_число | The date/time value from which you want to extract the month number. |
Returns the minute number (between 0 and 59) from the specified date/time value.
| дата_как_число | The date/time value from which you want to extract the minute number. |
НОМНЕДЕЛИ(дата_как_число, [тип])
Returns the week of the year of a given date.
| дата_как_число | The date/time value from which you want the week number. | ||||||
| тип | The method used to calculate the week number. The possible values are: | ||||||
| |||||||
| If this parameter is omitted it defaults to 1. |
РАБДЕНЬ(начальная_дата, количество_дней, [holidays])
Returns the working day that is the start date plus or minus a number of working days (weekdays), excluding any holidays.
| начальная_дата | The 'from' date. |
| количество_дней | 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 difference between two dates in the units that you specify.
| дата1 | The 'from' date. | ||||||||||||
| дата2 | The 'to' date. This should be greater than or equal to the 'from' date. | ||||||||||||
| единиц | The units in which you want the difference expressed. The possible values are: | ||||||||||||
|
Returns the serial number corresponding to the current date.
Returns the second number (between 0 and 59) from the specified date/time value.
| дата_как_число | The date/time value from which you want to extract the second number. |
Returns the hour number (between 0 and 23) from the specified date/time value.
| дата_как_число | The date/time value from which you want to extract the hour number. |
Returns the serial number corresponding to the current date and time.
ЧИСТРАБДНИ(начальная_дата, конечная_дата, [holidays])
Returns the number of working days (weekdays) between the start and end dates, excluding any holidays.
| начальная_дата | The 'from' 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. |