Find Difference between two Dates in Microsoft Excel
We all know Microsoft office Excel is been used in varied platforms. The power of Microsoft office excel varies from being a simple home budget calculator to a data sheet collecting sensitive information.
In a sheet which deals with two dates the difference between those needs to be calculated in most of the cases. Sometimes this type requirement is there for calculating the Age in any sheet. With the help of formulas in Microsoft office Excel we can achieve those.
In the following sheet I have two dates in A1 and B1 Cell. Please note that the cells are formatted as Date type.
In C1 I applied the formula DATEDIF(A1,B1,"y") .This calculates the difference between two dates entered in years.
For date difference in months and days
DATEDIF(A1,B1,"M") gives the difference in Months
DATEDIF(A1,B1,"D") gives the difference in Days
Get the current Date in a Cell.
Sometimes it’s required to enter current date in a cell. Today() function helps in doing so.
In the following example Microsoft office Excel sheet contains a DOB column and a formula column which calculates Age.
The formula I used here is DATEDIF(A2,TODAY(),"Y") which gives date difference between today and the date entered in column A.
With these simple steps of applying a formula we can find the date difference between two dates in all possible ways. Happy learning!
