» Calculating Number of Days, Weeks, Months and Years between Dates

Problem:

Calculating the difference between each pair of dates listed in columns
A & B.

Solution:

To calculate the difference in days, use the DATEDIF function as shown in the following formula:
=DATEDIF(A2,B2,"d")

To calculate the difference in weeks, use the INT function as shown in the following formula:
=INT((B2-A2)/7)

To calculate the difference in months, use the DATEDIF function as shown in the following formula:
=DATEDIF(A2,B2,"m")

To calculate the difference in years, use one of the following two solutions:
Use the DATEDIF function as shown in the following formula:
=DATEDIF(A2,B2,"y")

OR

Use the YEAR, MONTH, AND, and DAY functions as shown in the following formula:

=YEAR(B2)-YEAR(A2)-(MONTH(B2) To calculate the number of months over years, use the DATEDIF function as shown in the following formula:
=DATEDIF(A2,B2,"ym")

To calculate the number of days over years, use the DATEDIF function as shown in the following formula:
=DATEDIF(A2,B2,"yd")

Book Store:

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books

VIEW ALL BOOKS

Recommended Books:

• Financial Statement Analysis with S&P insert card
• Financial Risk Manager Handbook, Second Edition
• MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
• Special Edition Using Microsoft Word 2002
• Getting to Yes: Negotiating Agreement Without Giving In
• The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers

Email Tip

Print Tip

Add to My Tips

Rate This Tip

1 2 3 4 5

Rating: 3.52     Views: 330072

No comments have been submitted.

Click here to post comment

For Registered Users

Click here to Regiser

For Guest

Name

Comment Title

Comments