Second way: Using the 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 the date format). The C2 cell displays the subtracted result of these two dates. Simply use the minus “-“ between two dates.įor 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.įirst way – Subtract Dates in Excel by (-) operator.
