Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to get address of named range in Excel
  • How to get last row in text data in Excel
  • How to use Excel MMULT Function
  • How to use Excel VLOOKUP Function
  • How to use Excel FORMULATEXT function

Data Analysis Examples

  • Conditional Formatting Data bars Examples in Excel
  • Conditional Formatting Rules in Excel
  • How to Create Gantt Chart in Excel
  • How To Insert and Customize Sparklines in Excel
  • How to Create One and Two Variable Data Tables in Excel

Data Validation Examples

  • Excel Data validation must contain specific text
  • Excel Data validation allow uppercase only
  • Excel Data validation require unique number
  • Excel Data validation must begin with
  • Excel Data validation date in next 30 days

Add days to date in Excel

by

It you need to add days to date in Excel then this tutorials is for you. See example below:

To add a given number of years to a date, you can use the EDATE function.

Worked Example:   How to calculate next anniversary date or birthday in Excel

Formula

=date+days

Explanation

In the example shown, the formula in D5 is:

=B5+C5

How this formula works

Dates in Excel are just serial numbers. The number 1 represents January 1, 1900, the number 1000 is September 26, 1902, and so on.

Worked Example:   Calculate retirement date in Excel

When you have a valid date in Excel, you and just add days directly. Day values can be positive or negative.

For example, with a date in A1, you can add 100 days like so:

=A1+100

In the example shown, the formula is solved like this:

=B5+C5
=36861+7
=36868

Recall, Excel saves dates as number so when formatted as a date, 36868 is December 8, 2000.

Worked Example:   Add months to date in Excel

Post navigation

Previous Post:

Add decimal hours to time in Excel

Next Post:

Add days exclude certain days of week in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to count total words in a cell in Excel
  • Get first name from name with comma — Manipulating NAMES in Excel
  • How to count specific words in a range in Excel
  • MID, MIDB functions: Description, Usage, Syntax, Examples and Explanation
  • TRIM function: Description, Usage, Syntax, Examples and Explanation
  • Sum through n months in Excel
  • Convert Excel time to decimal minutes
  • Get last weekday in month in Excel
  • Excel Date & Time Functions Example
  • Convert Unix time stamp to Excel date
  • Compound Annual Growth Rate CAGR formula examples in Excel
  • How to calculate principal for given period in Excel
  • DURATION function: Description, Usage, Syntax, Examples and Explanation
  • Tax rate calculation with fixed base in Excel
  • NPER function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles