Date Arithmetic. Adding Dates You can add some number of days to a date by simply using the =SUM function. Since Excel stores dates as a number of days, no further work is required. For example, to add 5 days to 1/1/98, in A1, use =A1+5, which gives 1/6/98. To add a number of months or years to a date, you first need to decompose the initial date into its year, month, and day components, add in the desired offset, and then have Excel put the components back together. Excel will automatically handle the situation which arises when you pass a number greater than 12 to the MONTH function, or a number greater than 31 to the DAY function. For example, adding 6 months and 10 days to 8/25/97, in A1 with the formula gives 3/7/98. Generally, you cannot add two dates that are in serial format.
Note, however, that adding a month to a date may give you a result that you do not expect. You will get the date 3-March-2002, because the "31st" day of February, 2002, is 3-March. Subtracting Dates gives 9/25/96. DonationCoder.com.
PC World - 101 Fantastic Freebies. Once upon a time you actually had to pay for great software and services -- hard to believe, but true. Luckily, we no longer live in that world. The Internet is stuffed with great downloads and Web sites offering free software and services of every kind. Want to tune up your PC, keep it safe, create graphics, or back up your system with gobs of free storage space? You can find free software and sites to do all that, and plenty more. We revved up our cable modem and searched for the most intriguing free offerings out there. We didn't do it alone, though -- you helped. Also in This Article. Softwarecrew UK | Software News and Reviews. Code Sector Products. Adobe Tutorials and Training Online.