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 positive or negative.

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, so you'll subtract 15 days from

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 subtract days, months or years. One o