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

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 6, 2023
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

AI Formula Generator

Try for Free

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