HDTutorial
EN
How to Add Days to Dates in Excel

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Add Days to Dates in Excel

567,160 views October 26, 2018 12:15

Watch on YouTube
ChannelExcel Campus - Jon

Chapters

Description from the creator

In this video we look at 3 different ways to add or subtract days to dates in Excel using formulas, copy & paste, and VBA macros.

-- LINKS --
**Full blog post & file download**: excelcampus.com/vba/add-subtract-days-to-date/

--
*** JOIN OUR COMPREHENSIVE EXCEL TRAINING PROGRAM***
excelcampus.com/elevate
--
~ Learn my BLUEPRINT for Excel including when to use what tool (FREE TRAINING SESSION) excelcampus.com/blueprint ~
—
~Become an Excel Campus Insider (100% free) to access advanced workshops, bonus trainings, and weekly Excel tips: excelcampus.com/newsletter/

**3 Ways to Add or Subtract Days from Dates**

1. Use a FORMULA to add any number of days to a date. Dates are stored as numbers in Excel and formatted as a date. The date value (number) is the number of days that have elapsed since January 1, 1900. So we can add or subtract whole numbers to a date. Checkout my video on the how the date system works in Excel for more details (youtu.be/KlCAAQ_tQLA)

2. We can also use PASTE SPECIAL to add or subtract days. This technique allows us to modify the existing cells that contain date values. If the existing cells contain a formula, then the formula will be modified.

3. I also share some VBA MACROS that can be used to add or subtract days to dates. This is the most flexible technique that makes it easy for other users of our workbooks to quickly modify dates. We can create buttons and assign them to macros to add or subtract days from the dates in the selected cell(s).
**********
EXCEL FRIENDLY ACCESSORIES WE USE (Affiliate Links When Possible): LOGITECH KEYBOARD
Check out all the tech we use and recommend at excelcampus.com/store
**********

Please leave a comment below with any techniques you use to add days to dates. There are a lot of ways to go about this.
00:00 Introduction
00:40 Using a Formula
02:24 Using a Paste Special
05:00 Using an Existing Formula
06:26 Using a Macro

About this tutorial

Excel Campus - Jon published this 12:15 video tutorial on October 26, 2018. It has been watched 567,160 times on YouTube.

Category
Education
Duration
12:15
Published
October 26, 2018
Views
567,160
Likes
1,967

Tags

Share

Further reading

  • Excel formula: Add days to date | Exceljet exceljet.net

    Dates in Excel are just serial numbers. The number 1 represents January 1, 1900, the number 1000 is September 26, 1902, and so on. When you have a valid date in Excel, you and just add days directly. Day values can be p…

  • Add or subtract dates - Excel support.microsoft.com

    Add or subtract days from a date. Suppose that a bill of yours is due on the second Friday of each month. You want to transfer funds to your checking account so that those funds arrive 15 calendar days before that date,…

  • How to Add Days to a Date in a Spreadsheet in MS Excel ... techwalla.com

    An Excel spreadsheet is a document used to keep track of finances, contacts and other types of numerical data. When keeping track of data, the user often inserts a date. Excel has data functions and formulas to add or s…

This tutorial in other languages