As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Subtract Dates in Excel: A Step-by-Step Guide

In Excel, dates are represented by numbers, where each date is assigned a specific numerical value. You can subtract one date from another to calculate the number of days between them or subtract a specific number of days from a date to find a past or future date. This step-by-step guide will walk you through both processes.

How to Subtract One Date from Another

To find the number of days between two dates, subtract the earlier date from the later date. For instance, to calculate the days between December 31, 2015, and January 1, 2016:

  1. Select a cell and enter the formula: =42431-42370.
  2. Press Enter.
  3. The result, 61, represents the number of days between the two dates. You can use the same approach for dates in the past or future by subtracting the earlier date from the later one.

How to Subtract Days from a Date

To calculate a past or future date by subtracting or adding a specific number of days, use the following formula:

=EOMONTH(A1,-2)+B1

Here, "EOMONTH" is a function that returns the last day of the month, "A1" is the cell with the initial date, and "B1" is the cell with the number of days you want to subtract or add. For example, to find a date 60 days ago from December 31, 2015:

  1. Select a cell and enter the formula: =EOMONTH(A1,-2)+(-60).
  2. Press Enter.
  3. The result, 42310, represents the date 60 days before December 31, 2015. Adjust the formula by changing the sign or using a positive number to calculate future dates.

By following these steps, you can seamlessly subtract dates in Excel, whether you're determining the days between two dates or calculating a past or future date based on a specific number of days. Excel's date functions make such calculations straightforward and efficient.