Find the difference between two dates in excel?

Asked By abrahamahartman 60 points N/A Posted on - 12/09/2014

How does Excel store dates? How will excel calculate the difference between two dates? Can I create a formula for this operation? Is there any function in excel which will help to perform this operation with ease. What is its syntax? Please let me know where under Formulas can I find this function.

 

• Status: Open
• Question Views: 1790
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Sharath Reddy

Go To Solution

Best Answer

Best Answer

Answered By Sharath Reddy 590495 points N/A #141511

Find the difference between two dates in excel?

Yes, Microsoft Office Excel allows you to enter the date or a different date in a cell. But the difference is that, instead of displaying the actual month in words, it displays the equivalent number or the equivalent value of the month. For example, if the month you wish to display is June, instead of entering the word June, you need to enter 6 because it is the sixth month of the year.

The formula for date is =DATE(year,month,day). So, to enter a specific date on a cell for example March 25, 1988, type without quotes “=date(1988,3,25)” then hit Enter. It should now display the date you entered. See image.

This is how Microsoft Office Excel displays the date by default. But if you don’t like the way the date is displayed, you can always change the format of the date. You can make Microsoft Office Excel display the month in words as well as display the day of the week the date falls. See image.

To change the format of the date, right-click on the cell that contains the date formula then select Format Cells. See image.

In Format Cells dialog box, select Number tab then select Date from the Category. Select the date format you wish to use then click OK. And that’s it. The new format will be applied to your date. See image.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 12/14/2014
• Question Category: MS Excel

Answered By Nothman tale 0 points N/A #200168

Find the difference between two dates in excel?

Excel store dates as a number of days from 1900-Jan-0



To calculate the difference we can subtract two cells with ‘-‘ operator containing the dates.

In our case we have dates in cell ‘A3’ and cell ‘A2’

=A3-A2 (Days between the two dates)

=NETWORKDAYS(A2,A3) (Weekdays between the two dates)

=MONTH(A3)-MONTH(A2) (Months occurring between two dates in the same year)

=YEAR(A3)-YEAR(A2) (Years occurring between two dates)



You can find it under the tab of “FORMULAS” then from drop doen menu of “Date & Time”

About Nothman tale

Questions
0

Answers
77

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 12/29/2014
• Question Category: MS Excel