HomeMicrosoft OfficeExcelHow to add or subtract days in Microsoft Excel ?

How to add or subtract days in Microsoft Excel ?

In Microsoft Excel 2016 , you can easily add or subtract days directly by using the + or – operator.

How to add or subtract days in Microsoft Excel ?

Assume that that current date is 15 October, 2016 and is entered in the cell A1 and you want to add 12 days to it.

Here’s the formula to do it.

=A1+12

image

To subtract the number of days from the current date entered in the cell A1 , here’s the formula.

image

Leave A Reply

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

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021