Today lets talk about indexing a technique used to compare changes in values.

We just need to use the help of a dash or minus sign ( - ) in the formula writing on our cells. Subtract Date In Excel How To Subtract Date In Excel Examples. How to do that in excel Actually, it is pretty easy. Excel offers several methods to unhide the hidden rows in different ways. Either write a mathematical equation to subtract one cell from another or use the SUM function to subtract several cells at once. You can subtract it from timestamp to get only date. So if the two dates had been 5 years and 364 days apart, the answer would still be 5. Excel 2013 doesnt have a SUBTRACT function as you might expect, but the program does provide two options for subtracting cells from one another. For example the formula on row 4 shows 5 years, even though the two dates are a little more than 5 years apart. Note that the answer only shows complete units. Column D shows the formula that was actually used in column C to get the result shown in column C. The table below shows sample formulas using each of the unit options. There are 3 additional more unusual options that are explained in the example below. Unit meaning the unit of measure, can be “D”, “M”, or “Y” for day, months, or years respectively. Start date and end date are self explanatory. The format for the function is DATEDIF(start date,end date,unit). The explanation I heard for this is that it isn’t a standard Excel function, it is only included for backward compatibility with Lotus 1-2-3. You won’t find this one in the function wizard so you will have to remember how to type it in yourself. The best way is to use the DATEDIF() function. If you want to know the number of months or years between two dates, things get trickier. Step by step: Type A1() Type 100-50 Hit enter Tip: You can add more values into the formula by typing (-) between the cells. But all you have to do is set the formatting for that cell to General or to any number format (right-click > choose Formatting) to make the result show as 29. Excel may automatically format the cell with the formula in it as a date, which means instead of seeing 29, you’ll see. For example if cell A2 has an invoice date in it of and cell B2 has a date paid of, then you could enter use the formula =B2-A2 to get the number of days between the two dates, or 29. If need to know the number of days between two dates, that is very easy to do in Excel.

Subtraction formula in excel