How to Add Days to Dates in Excel




About this tutorial:

Video duration: 00:12:15
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.

Download the file used in the video at:

Here is a quick overview of the three techniques explained in the video:
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…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads