Скачать или смотреть Advance Date Functions in Excel | Date functions in excel

#ArvindTechz

Cell Referencing in Excel
   • Cell Referencing in Excel | Relative Refer...  

Topics Covered
=============

 DAYS (00:23)
Syntax: = DAYS( end_date, start_date )
The Excel Days function returns the number of days between two supplied dates.

 DAYS360 (01:55)
Syntax: =DAYS360( start_date, end_date, [method] )
The Excel Days360 function returns the number of days between 2 dates, based on a 360-day year (12 x 30 months).
US vs. European Method
US Method:
If the start date is last day of a month it is set to the 30th of that month;
If the end date is last day of month, then:
If the start date is the last day of month, the end date is set to the 1st of the following month;
Otherwise, the end date is set to the 30th of that month.
European Method:
If the start date is the last day of the month it is set to the 30th of that month;
If the end date is the last day of the month, then it is set to the 30th of that month.

 DATEVALUE (03:33)
Syntax: =DATEVALUE( date_text )
The Excel Datevalue function converts a text representation of a date into an Excel date.

 TIMEVALUE (04:56)
Syntax: =TIMEVALUE( time_text )
The Excel Timevalue function converts a text representation of a time, into an Excel time.

 WORKDAY (05:41)
Syntax: =WORKDAY( start_date, days, [holidays] )
The Excel Workday function returns a date that is a supplied number of working days (excluding weekends and holidays) ahead of a given start date.

 WORKDAY.INTL (08:41)
Syntax: =WORKDAY.INTL( start_date, days, [weekend], [holidays] )
The Excel Workday.Intl function returns a date that is a supplied number of working days (excluding weekends and holidays) ahead of a given start date. The function allows the user to specify which days of the week are counted as weekends.

 NETWORKDAYS (10:31)
Syntax: =NETWORKDAYS( start_date, end_date, [holidays] )
The Excel Networkdays function calculates the number of work days between two supplied dates (including the start and end date). The calculation includes all weekdays (Mon - Fri), excluding a supplied list of holidays.

 NETWORKDAYS.INTL (13:20)
Syntax: =NETWORKDAYS.INTL( start_date, end_date, [weekend], [holidays] )
The Excel Networkdays.Intl function calculates the number of whole work days between two supplied dates, excluding weekends and holidays. The function allows the user to specify which days are counted as weekends and holidays.

 ISOWEEKNUM (13:52)
Syntax: = ISOWEEKNUM( date )
The Excel Isoweeknum function returns the ISO week number of a supplied date.

 WEEKNUM (15:13)
Syntax: = WEEKNUM( serial_number, [return_type] )
For a given date, the Excel Weeknum function returns an integer representing the week number (from 1 to 53) of the year.
[return_type] Meaning
1 Week runs from Sunday to Saturday; Uses numbering system 1
2 Week runs from Monday to Sunday; Uses numbering system 2
11 Week runs from Monday to Sunday; Uses numbering system 11
12 Week runs from Tuesday to Monday; Uses numbering system 12
13 Week runs from Wednesday to Tuesday; Uses numbering system 13
14 Week runs from Thursday to Wednesday; Uses numbering system 14
15 Week runs from Friday to Thursday; Uses numbering system 15
16 Week runs from Saturday to Friday; Uses numbering system 16
17 Week runs from Sunday to Monday; Uses numbering system 17
21 Week runs from Monday to Sunday; Uses numbering system 21

 DATEDIF (16:20)
Syntax: =DATEDIF(start_date, end_date, unit)
Calculates the number of days, months, or years between two dates.

 WEEKDAY (18:36)
SYNTAX: = WEEKDAY( serial_number, [return_type] )
The Excel Weekday function returns an integer representing the day of the week for a supplied date

 EOMONTH (12:10)
Returns a date that is the last day of the month which is a specified number of months before or after an initial supplied start date
Syntax: = EOMONTH( start_date, months )
Function Description:
The Excel Eomonth function returns the last day of the month, that is a specified number of months before or after an initial supplied start date.


Keywords:
#ArvindTechz
#Ms Excel
#Excel
#ExcelDateFunctions