How to add days to a date in a spreadsheet in MS excel

Written by lysis
  • Share
  • Tweet
  • Share
  • Email

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 of these functions is the "Day()" function, which is used to calculate the day in a specific date.

Skill level:
Moderate

Other People Are Reading

Instructions

  1. 1

    Open the Excel spreadsheet you want to edit. You can also create a new spreadsheet to test the date formulas. When you start Excel from the Windows Start menu, a new spreadsheet is automatically created.

  2. 2

    Enter a date into the first cell labelled "A1." This can be any date of the year even if it's the last day of the month or year. When you add a day to the date, Excel automatically transitions the date to the following month or year.

  3. 3

    Use the "Day()" formula to add to the days. Enter the new formula in a cell adjacent to the A1 cell. The following code adds 10 days to the date in the A1 cell:

    =date(year(a1), month(a1), day(a1) + 10)

    The equal sign indicates a formula is entered, and it is required by Excel. The "date()" function turns the year, day and month into a full date string.

  4. 4

    View the results of the formula. Notice that there are 10 days added to the date in the A1 cell. Additionally, if you change the date in the A1 cell, the formula updates and reflects the changes.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.