Using the YEAR, MONTH, and DAY Functions - Exercise

Contact Us or call 1-877-932-8228
Using the YEAR, MONTH, and DAY Functions - Exercise

Using the YEAR, MONTH, and DAY Functions

Duration: 5 to 15 minutes.

In this exercise, you will practice using the YEAR, MONTH, and DAY functions.

  1. Open Functions.xlsx from your Excel2013.2/Exercises folder and go to the sheet named "Date".
  2. Use the YEAR, MONTH, and DAY functions to add the years, months, and days of the dates found in column A to columns B, C, and D.

Solution:

  1. To add the year of the dates found in column A to column B:
    1. In the sheet named "Date", select cell B2.
    2. On the FORMULAS tab, in the Function Library group, click the Insert Function command:Insert Function Command
    3. In the Insert Function dialog box:
      1. Search on "Year" or, in the Or select a category drop-down box, select Date & Time.
      2. Under Select a function, select YEAR.
      3. Click OK.YEAR
    4. In the Function Arguments dialog box:
      1. In the Serial_number field, enter cell A2.
      2. Click OK.Serial_number Field
    5. Copy cell B2 to cells B3:B6.
  2. To add the month of the dates found in column A to column C:
    1. In the sheet named "Date", select cell C2.
    2. On the FORMULAS tab, in the Function Library group, click the Insert Function command:Insert Function Command
    3. In the Insert Function dialog box:
      1. Search on "Month" or, in the Or select a category drop-down box, select Date & Time.
      2. Under Select a function, select MONTH.
      3. Click OK.MONTH
    4. In the Function Arguments dialog box:
      1. In the Serial_number field, enter cell A2.
      2. Click OK.Serial_number Field
    5. Copy cell C2 to cells C3:C6.
  3. To add the day of the dates found in column A to column D:
    1. In the sheet named "Date", select cell D2.
    2. On the FORMULAS tab, in the Function Library group, click the Insert Function command:Insert Function Command
    3. In the Insert Function dialog box:
      1. Search on "Day" or, in the Or select a category drop-down box, select Date & Time.
      2. Under Select a function, select DAY.
      3. Click OK.DAY
    4. In the Function Arguments dialog box:
      1. In the Serial_number field, enter cell A2.
      2. Click OK.Serial_number Field
    5. Copy cell D2 to cells D3:D6.
Next