Using the New Excel Functions - Exercise

Contact Us or call 1-877-932-8228
Using the New Excel Functions - Exercise

Using the New Excel Functions

Duration: 5 to 10 minutes.

In this exercise, you will use one of the new functions available in Excel 2013.

  1. Open New Functions.xlsx from your Excel2013.2/Exercises folder.
  2. Use the new DAYS function to determine the amount of time between the two dates that are listed in Column A.

Solution:

  1. Select Cell B2
  2. Select the FORMULAS tab and in the Function Library group, select the Date & Time tab.
  3. Select DAYS.
  4. In the Function Arguments dialog box, enter "A3" as the End_date and "A2" as the Start_date and click OK.
  5. Notice that 56 days are between these two dates.
Next