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.

Ms excel formula to subtract 4 hours