» Calculating Number of Days, Weeks, Months and Years between Dates
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
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)
=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:
Recommended Books:
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- Financial Peace: Revisited
- Seven Habits Of Highly Effective People
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
Need date formula
Chuck Miller
I am looking for a date formula which will announce "Due to Expire" when a date is 2 months from expiration. Does anyone know of such a formula?
Calculating Number of Days, Weeks, Months and Years between Dates
Migdad
Dear,
how can I calculate the days between two dates (Excluding the weekends)
I am working in Saudi Arabia and the weekends over here are Thursday and Friday.
please send me the answer to Migdad@hotmail.com
abc
yogita
how can I calculate the days between two dates (Excluding the sunday only)?
Dates
Kumodi74
I am looking for a fomula that will calculate the amount of days between 2 dates excluding weekends
Dates
Dee
I am looking for a fomula that will calculate the amount of days between 2 dates excluding weekends
Excluding the weekend
Not Reallyhere
You are a doofus, set your time to a realisic time zone.
counting days between two dates including both
DPS
I am looking for a formula to count all days between two dates including start and end date - currently one of the days is dropped when using the formula.
