Subscribe to our YouTube Channel for more Videos

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

Senthil Kumar B
Senthil Kumar is a former Microsoft MVP (Most Valuable Professional). He is a Co-Author of the book "Windows 10 Development Recipes using JavaScript and CSS" for Apress Publication. He is a technical presenter, blogger, mentor and a Geek.  Senthil is a regular speaker is various local user groups. He has presented at conferences like Great Indian Developer Summit (GIDS) & Microsoft DevCamps. You can reach out to him via his Twitter handle @isenthil.