Skip to content

How To Subtract

  • Excel
  • Google Sheets
  • Calculators
  • Other Apps
  • Programming
  • About

Excel

How to subtract in Microsoft Excel: cells, columns, percentages, dates, times and more.

Excel

How to Subtract Two Columns in Excel

November 19, 2026 by Matthew Burleigh

Subtract two columns in Excel with =B2-C2 and the fill handle, one spilling formula, a locked reference, a table or Paste Special, plus fixes for common errors.

Categories Excel
Excel

How to Subtract Time in Excel

November 19, 2026 by Matthew Burleigh

Subtract time in Excel with =end-start, format the result as h:mm or [h]:mm, convert it to hours or minutes, and handle shifts that cross midnight.

Categories Excel
Excel

How to Subtract Multiple Cells in Excel

November 19, 2026 by Matthew Burleigh

Subtract multiple cells in Excel with =B2-SUM(B3:B7), a minus chain, negative numbers, absolute references or Paste Special, plus fixes for #VALUE! errors.

Categories Excel
Excel

How to Subtract in Excel

November 19, 2026 by Matthew Burleigh

Subtract in Excel with the minus sign: cell from cell, whole columns, a fixed number, Paste Special, and fixes for #VALUE!, negatives and wrong results.

Categories Excel
Excel

How to Subtract Dates in Excel

November 19, 2026 by Matthew Burleigh

Subtract dates in Excel with a simple minus formula, DAYS, DATEDIF or NETWORKDAYS, go back days, months or years, and fix results that show as dates or #####.

Categories Excel
Excel

How to Subtract a Percentage in Excel

November 19, 2026 by Matthew Burleigh

Subtract a percentage in Excel with =A2*(1-B2), reduce a whole column with Paste Special, subtract one percentage from another, and fix wrong results.

Categories Excel

Browse topics

  • Calculators (4)
  • Excel (6)
  • Google Sheets (4)
  • Other Apps (3)
  • Programming (3)

About this site

How To Subtract has step-by-step guides for subtracting in Excel, Google Sheets, calculators and code, written by Matthew Burleigh. Learn more.

  • About
  • Contact
  • Privacy Policy
  • Terms of Use
  • Disclaimer
© 2026 How To Subtract