In this article we will teach you in a simple and explained step by step way so that you can make it happen.
How many times have you wanted program or calculate future dates so that at the end of a project we can view it and anticipate other activities, i.e. it shows us the exact date when we will finish a project or we will have some important event that you document in an Excel file.
How to add or subtract days to a date in Excel?
We will give an example that you would like to calculate the due date of the monthly invoices and this will be done in Excel, in this way you can manage it by following the steps that we will explain below.
First you need to make the organization table, with separators between the columns: Expiration date, +/- Days and then, finally, Data di transfer of money to pay for the service.
In the first row you will indicate the date of its last expiration and in the next row of days you will enter the number of days to subtract or add from the initial expiration date.
In the last cell where we put the date of transfer or payment of the money, we will do the following formula: A2 (the first line "Deadline") + B2 (the second line where we put the days to add or subtract).
At the end of the formula we will have as a result in the Transfer Date row the results will be observed and therefore have full control of the new expiration date.
This formula can be used in as many cells as needed to perform the same calculation.
How to add or subtract months to a date in Excel?
To start we need to create a table similar to the previous one with different characteristics, for example by inserting a start date with day and month in the first row.
So, in the second row we need to place the months we want to subtract or add to the date we add in the first row.
And finally, in the last row we need to place the formula to be able to find the end date, the formula will be: = EDATE and in quotes we will place "A2" ( Start date we put inside the first line) + “B2” (number of months to subtract or add that we put in the second row).
How to add or subtract a combination of days, months and years in Excel?
To start we have to make the table by inserting in the first row «Date» with day, month and year of what we have to calculate.
So we need to open a new row in which we will place «+/- years »And therefore be able to place the number of years we want to subtract or add to the date in the first row.
In another row that would be the third of the table, we will position " +/- months »And we will place the figure we need to subtract or add to our starting date.
In a penultimate line we have to enter the days, " +/- days »That we will subtract or add to the initial date.
In this way, in the last line we will place «Result» and there it will give us the final figure with the sums and subtractions that have been changed in the following lines from the starting date.
With these options you will be able to make changes to the dates, thus being able to change the due dates and be aware of the important dates in your daily life with this tool. Most importantly, you can also learn how to automatically multiply in Excel in the simplest way possible. We also recommend that you learn how to use the most useful shortcuts you can create with the keyboard so that the process is much easier and more effective.
If this article helped you, you can find many more at miracomosehace.com where you will find guides on tools like Excel, Word and Powerpoint step by step and above all free guides.
