Skip to content

How To Subtract

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

Google Sheets

How to subtract in Google Sheets on the web and on mobile.

Google Sheets

How to Use the MINUS Function in Google Sheets

November 19, 2026 by Matthew Burleigh

Learn how to use MINUS in Google Sheets to subtract two cells, fill a column with ARRAYFORMULA, work with dates and times, and fix #VALUE! and sign errors.

Categories Google Sheets
Google Sheets

How to Subtract Time in Google Sheets

November 19, 2026 by Matthew Burleigh

Subtract time in Google Sheets with =B2-A2 and Duration format, fix overnight shifts with MOD, take hours off a time, and convert results to decimal hours.

Categories Google Sheets
Google Sheets

How to Subtract in Google Sheets

November 19, 2026 by Matthew Burleigh

Subtract in Google Sheets with =A2-B2, the MINUS function, SUM for long lists and ARRAYFORMULA for columns, plus fixes for #VALUE!, wrong signs and formats.

Categories Google Sheets
Google Sheets

How to Subtract Dates in Google Sheets

November 19, 2026 by Matthew Burleigh

Subtract dates in Google Sheets with =B2-A2, DAYS, DATEDIF or NETWORKDAYS to get days, months, years or workdays, plus fixes for 1900 dates and #VALUE! errors.

Categories Google Sheets

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