Question: A useful Excel function is DATEDIF. This formula will calculate the difference between 2 dates. =DATEDIF(StartDate, EndDate, Interval) The interval can be Y, M, D,

A useful Excel function is DATEDIF. This formula will calculate the difference between 2 dates.

=DATEDIF(StartDate, EndDate, Interval)

The interval can be Y, M, D, YM, MD and YD.

Example: If you were born on January 5, 1988 and you want to know how old you are as of February 4, 2019, then just copy and paste the following in a cell in Excel and press enter

=DATEDIF("05-Jan-1988","04-Feb-2019","Y")

For our Discussion:

1) Choose a person. The person could be yourself, a friend, family, celebrity, mentor, historical person, etc.And find out how old that person is or would be (if he or she is no longer alive).

2) Explain the significance of that person.Why did you chose this individual?

3) Now for the business part of this discussion. How might someone use that function for a business situation?(maybe using the function within a formula as part of another calculation).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

1) Choose a person. The person could be yourself, a friend, family, celebrity, mentor, historical person, etc.And find out how old that person is or would be (if he or she is no longer alive). 2)...

please help DATE VALUE VALUE MEASURECurrentDate(TODAY)CurrentTime(NOW)VALUE#N/AFORMULA#N/A Use E6 "Problem Date" for green cells in col. E \& I 11/11/2019 Problem Date Year (YEAR) Month (MONTH) \#N/A...

n cells A2:A6 you will find numbers. We would like to change those numbers into actual dates using cells B2:B6. To accomplish this, enter =A2 into cell B2. That will essentially copy A2 into B2 using...

Question 1 0 / 1 0 Submit Video Question Content Area Introduction When conducting analysis in Excel for business related problems, you will likely encounter the data type of "date" quite often. Many...

Introduction When conducting analysis in Excel for business related problems, you will likely encounter the data type of "date" quite often. Many elements of business are tied to dates. As such,...

elaborate a one to two (1-2) paragraph max analysis from your work up to this point. Your report should consider: What business recommendations will you give Label XYZ in regards to the...

The Excel file associated with this exercise includes a sheet ( Inventory Data Sheet ) with information regarding Lain Company's inventory including unit cost, cost of disposal, unit selling price,...

The Excel file associated with this exercise includes a sheet (Inventory Data Sheet) with information regarding Lain Companys inventory including unit cost, cost of disposal, unit selling price, and...

The Excel file associated with this exercise includes a sheet (Inventory Data Sheet) with information regarding Lain Company's inventory including unit cost, cost of disposal, unit selling price, and...

Analyze a companys financial statements in terms of liquidity, profitability and long-term solvency, and cash flows from operations. Prepare in good form a written presentation of the results of the...

Falconer Company had net (after-tax) income last year of $1,100,000 and operating assets of $3,000,000. Falconers actual cost of capital was 11 percent. Required: 1. Calculate the EVA for Falconer...

What is the total direct labor costs for a week if 4 0 hr . week, hourly rate at $ 6 . 0 0 , 1 8 hrs overtime, 1 supervisor cost at $ 3 0 0 per week / 8 hrs .

Which of the following is (are) true of culture? I. It is most accurately captured in theoretical typologies and classifications (e.g., Hofstedes) II. It determines how a group of people behave,...

2. In what way can we say that method affects the result we get?

4. In what way will relationships in a system influence what is reported?

3. Mention three examples where you distorted information that you had taken from your memory and where others made you aware of the fact that you had distorted the information. Did it create a...