Excel Formulas to Add or Subtract Days From the Given Date!!
Tags: excelformula, excelformulas
Published: 2021-04-28 09:51:37

---
title: Excel Formulas to Add or Subtract Days From the Given Date!!
published: true
date: 2021-04-27 08:00:05 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-add-or-subtract-days-from-the-given-date/
---

Assume that you have a list of dates, and you need to add the number of days to the date. If you identify and count them one by one, it will waste a lot of time. So here we will discuss how to **add or subtract days from the given date in Excel**. Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Add or subtract date to the given date](https://geekexcel.com/wp-content/uploads/2021/04/add-or-subtract-date-to-the-given-date.png)](https://geekexcel.com/excel-formulas-to-add-or-subtract-days-from-the-given-date/add-or-subtract-date-to-the-given-date/#main)<figcaption id="caption-attachment-34818">Add or subtract date to the given date</figcaption>

## General Formula:

- You can use the below formula to add or subtract the days from the current date.

**=date+days**

## Syntax Explanations:

- **Date** – It specifies the input dates.
- **Days** – It represents the number of days that want to add or subtract from the input date.
- **Plus operator (+)** – This symbol is used to add the values.

## Practical Example:

Let’s consider the below example image.

- Here we will enter the input dates in **Column B**.
- Now we are going to add or subtract the number of days given in **Column C**.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/04/Input-Ranges-32.png)<figcaption id="caption-attachment-34816">Input Ranges</figcaption>

- So, apply the above-given formula to the [**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section and press the  **ENTER**  key.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/04/Enter-the-formula-24.png)<figcaption id="caption-attachment-34815">Enter the formula</figcaption>

- Finally, we will get the result in the selected cell.

![Result](https://geekexcel.com/wp-content/uploads/2021/04/Result-33.png)<figcaption id="caption-attachment-34817">Result</figcaption>

## Bottom-Line:

From this short tutorial, you can get some clarification on how to **add or subtract days from the given date in Excel**. Hope that this article is useful to you. Please share your **query** below in the **comment** box. We will assist you. Thank you so much for visiting our site. Click here to know more about **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Related Articles:

- **[Excel Formulas to Round up the Value to the Nearest 5s ~ Easy Guide!!](https://geekexcel.com/excel-formulas-to-round-nearest-5s/)**
- **[Excel Formulas to Add the Business Days to Date ~ Easy Guide!!](https://geekexcel.com/excel-formulas-to-add-the-business-days-to-date-easy-guide/)**
- **[Formulas to Get Integer Part of a Number ~ Quick Tricks!!](https://geekexcel.com/excel-formulas-to-get-integer-part-of-a-number/)**