How to subtract 6 months off a date in Excel:

1. Select the cell where you want to display the new date.
2. In that cell, type the formula
   Code:

   =EDATE(A1,-6)

   (without the quotes).
3. Replace "A1" with the cell reference of the original date you want to subtract 6 months from.
4. Press Enter.
5. The new date will be displayed in the selected cell in the format of a date.

That's it! The function in Excel allows you to add or subtract a specified number of months from a date. In this case, we used "-6" to subtract 6 months from the original date.