After selecting all the working cells, you can hit keyboard strokes Ctrl + D.Įxample #2 – Two Dates in Number of Years Step 3: Drag the formula until the last working row, and you can see the difference between all dates in a number of days, as shown below. You now can see the difference between the two dates as a number of days as shown below: Step 2: Select the entire column C and click on the Home tab under the Number group section select General or Number formatting through the dropdown list to convert it into numbers. Press the Enter key, and you’ll get the difference between the two dates as shown below: Step 1: In cell C2, use a usual subtraction method to subtract the First Date from the Second Date.
