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…