Excel can easily let you know how much day are left for the date you are seeking for.
A Simple Calculated formula you can use to measure a difference in two or more dates.
For calculating Date Diffidence in Excel follow these simple steps.
1. Finding Out the No of Days between two dates.
| Finding Out the No of Days between two dates |
If you want to find out No of days between two days in MS Excel then it is most simple way just you have to add a “d” in Datediff Formula.
Sample Formula: =DateDif(A1,A2,”d”)
or you can also use =A2-A1
Both formulas will give you the same answer.
2. Finding Out the No of Month between two dates.
| Finding Out the No of Month between two dates. |
if you want an answer of difference in dates in Months in Ms Excel then you can just add “m” in Datedif Formula.
Sample Formula: =DateDif(A1,A2,”m”)
3. Finding Out the No of Years between two dates.
| Finding Out the No of Years between two dates. |
You can also find you the difference of Year with in two dates by using the same formula, you have to enter just “y” in same formula.
Sample Formula: =DateDif(A1,A2,”y”)
You can also Ignore some of the date Part for taking out the difference by using Same formula
4. Finding Out the No of Days ignoring Years between two dates.
| Finding Out the No of Days ignoring Years between two dates |
If you want to find out the no of days and you also wants to ignore the years between two dates then you can easily use the same formula by adding “yd”
Sample Formula: =DateDif(A1,A2,”yd”)
5. Finding Out the No of Days ignoring Month between two dates.
| Finding Out the No of Days ignoring Month between two dates. |
If you want to find out the no of days ignoring Month between then you can use “md”.
Sample Formula: =DateDif(A1,A2,”md”)
6. Finding Out the No of Months ignoring Years between two dates
| Finding Out the No of Months ignoring Years between two dates |
If you want to find out the no of days ignoring Years between then you can use “ym”.
Sample Formula: =DateDif(A1,A2,”ym”)
goharsaeed1 