Getting years difference by simply subtracting two dates If you have no idea about the DATEDIF function, the following example should make it clear: For that, use the “D” value for the unit in DATEDIF function. You may also use DATEDIF function for the difference between two dates. Using DATEDIF function for getting the difference of days See the following example of subtracting TODAY() by DOB by using “-“: You may use the TODAY() function for getting the difference between current day and a given day e.g. The example of subtracting given date with today See what it resulted from the same date as I used ‘+’ for addition: In the same way, you may add days, numbers and years in the given date by using this formula: Similarly, the YEAR function subtracted 2 years.Īt the end, the DATE function combined all three and resulted in. The MONTH function took the March from the given date and subtracted 2 months. The DAY function got the day from the given E2 cell date and subtracted 2. In the formula, I used YEAR, MONTH and DAY functions inside the DATE function. First, have a look at the formula and result and I will explain a little: In this example, you may enter a date in the D3 cell and DATE formula will subtract 2 years, minus 2 months and minus 2 days from that date and display the resultant date in D4 cell. Using DATE function to subtract Years/Months and Days You can see this dropdown under the Home in the ribbon. See the graphic below where you may ensure it: Just make sure that the C2 column or cell wherever you are displaying the result after subtraction is using the general format (and not date format). The C2 column displays the subtracted result of these two dates. Simply use the minus “-“ between two dates as shown in the example below.įor the example, the A2 and B2 cells are given dates. This is the simplest way of subtracting two dates and getting the number of days. You may get the number of days, months and years by using these ways along with adding or subtracting and getting the resultant dates. There is a number of ways for calculating the difference between two dates in Excel.

Formula to add days to date in excel