The Importance of DATE Functions
Make sure to review Chapter 7. In this unit, you learned how to use a number of DATE Functions like, YEAR AND YEARFRAC.
- Why are these DATE Functions important in Excel?
- Pick one of the DATE Functions used in this unit or pick one found in Table 7.1 on Page 438. (ON PAGE 2 OF THE ATTACHED DOCUMENT)
- Explain how it is used and when it could be used in Excel.
Table 7.1 Date Functions
Function Description Syntax
DATE function
Displays the date when provided with the numeric year, month, and date arguments; useful to display a complete date that is built from individual cells containing the year, month, and day =DATE(year,month,day)
DAYS360 function Calculates the number of days between two dates based on a 360-day year using 30 days per month =DAYS360(start_date, end_date,[method])
EDATE function Displays the serial number representing a date X number of months in the future or past from a given date; use a minus sign at the beginning of the months argument to calculate the serial number for a date in the past =EDATE(start_date, months)
EOMONTH function Displays the serial number representing the last day of a month that is X number of months from a given date; use a minus sign at the beginning of the months argument to calculate the serial number for a date in the past =EOMONTH(start_date,months)
ISOWEEKNUM function Returns the number of the week within the year for the specific date
=ISOWEEKNUM(date)
NETWORKDAYS function Calculates the number of work days (excluding weekends) between two dates; can optionally exclude federal and state holidays as well as other nonwork days
=NETWORKDAYS(start_date,end_date,[holidays])
WORKDAY function Calculates a serial number of a date, given a specified number of days before or after a date, excluding specified holidays =WORKDAY(start_day, days,[holidays])