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

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Reply


x

Interesting BlogPosts to read

How to print title on every page in Microsoft Excel?
Most of the time we might end up having a long workbook with huge amount of data and they have lot o...
How to quickly remove multiple line breaks in Excel using VBA code?
There are times when you might copy few data from different source and you would end up getting unne...
How to change orientation of the worksheets in Microsoft Excel ?
This blog post will show the steps that are needed to change the orientation of the current workshee...