We Value Your Privacy

We and our partners use technology such as cookies on our site to personalise content and ads, provide social media features, and analyse our traffic. Click below to consent to the use of this technology across the web. You can change your mind and change your consent choices at anytime by returning to this site.

Update Consent
Loading ...

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

Updated June 02, 2017

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.

Loading ...
  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. 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. 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:

  4. \=date(year(a1), month(a1), day(a1) + 10)

  5. 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.

  6. 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.

Loading ...

About the Author

Lysis is the pen name for a former computer programmer and network administrator who now studies biochemistry and biology while ghostwriting for clients. She currently studies health, medicine and autoimmune disorders. Lysis is currently pursuing a Ph.D. in genetic engineering.

Loading ...