answersLogoWhite

0


Best Answer

DATEDIF function computes the difference between two dates in a variety of different intervals, such as the number of years, months, or days between the dates.

Syntax for DATEDIF: =DATEDIF(Date1, Date2, Interval)

Date1 = first date

Date2 = second date

Interval = interval type

Interval Types:

m = Months (complete calendar months between dates)

d = Days (number of days between dates)

y = Years (complete calendar years between dates)

ym = Months Excluding Years (complete calendar months between dates like they were in the same year)

yd = Days Excluding Years (complete calendar days between dates like they were in the same year)

MD = Days Excluding Years And Months (complete calendar days between dates like they were in the same month and same year)

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you use the datedif function in Microsoft Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How do you do standard deviation on Microsoft Excel?

Use the STDEV() function.


How do you use the all function in Excel?

you can get help in the Microsoft excel itself by pressing F1 key.


What is the step function of Microsoft Excel?

There is no step function in Excel. However, you can use excel to create a Step Function Chart. See related links for a video to explain the process.


Do radiological technician use Microsoft Excel?

Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.Yes, a radiological technician could use a spreadsheet such as Microsoft Excel in their work.


Looking for advice on Excel's amortization calculator?

Yes it is easy to use it you are familiar with Microsoft Excel. If you are having trouble you can always use the help function within the program.


Why is Excel not itself database but can be used as database?

Microsoft Excel is not a database, it is a spreadsheet. You could use it for a rudimentary database application, but that is not it's primary function.


In Microsoft Excel functions can be entered using what?

You can enter them by just typing them in with the keyboard. You can also use the Insert Function facility.


How do you use Excel for typing Microsoft Word?

Excel and Microsoft word are two different programs. To ask how to you use excel for typing ms word does not make sense


How can you use Excel at home and at work?

go on to Microsoft excel and do what you want


Why do pharmacy technicians use Microsoft Excel?

Pharmacy technicians use Microsoft Excel because it is a fast and efficient means of organizing data.


What do you mean by Microsoft Excel?

Microsoft is a brand like Addidas or Prada. Excel is a programme that you use for producing spreadsheets.


What is delta in a spreadsheet?

Delta is a function in an Excel spreadsheet that denotes the syntax of a series of numbers. Excel is a spreadsheet program created by Microsoft that many businesses and families use for budgets and accounting.