Return to Excel Formulas List

Add or Subtract Days to a Date in Excel & Google Sheets

Download Example Workbook

Download the example workbook

This tutorial will demonstrate how to add (or subtract) days to a date in Excel and Google Sheets.

Add Days to Date Main

Add Days to a Date

Dates in Excel are stored as serial numbers where each whole number represents a unique day:

DATE Serial number

This makes adding or subtracting dates extremely easy. Simply add a number of days directly to the date:


Add Dates

Subtract Days From a Date

Of course, you can subtract days in the same way:


subtract days

Add Business Days to a Date

Excel also provides you with functions to work with Business Days. Specifically the WORKDAY Function allows you to add business days to a date:


Add Workday

Subtract Working Days

Or you can subtract working days the same way:


subtract Workday

Adding Days in Google Sheets

The above examples work exactly the same in Google Sheets as in Excel:

Add Days to Date Google Sheet

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List