In this video we discuss how to calculate or find the date a certain number of months in the future or past from a given date in excel. We go through a few examples step by step
Transcript/notes
Let’s say that you need to know the date, a certain number of months in the past, or in the future, such as for an expiration, maturity or due date, as I have set up in this example.
In column A, we have a date, and in column B we have a number of months. We want to know, what is the date, 4 months from 2/22/2019.
We are going to put the answer in cell C2, so left click on cell C2. Next, we type in an equals sign, then we type in the letter e, and a drop down box will appear. In the box, left double click on EDATE.
From here, we need to enter the start date, so left click on cell A2, and next, type in a comma. Now we enter the number of months, so, left click on cell B2. Then type in a closed parenthesis to close off the function, and then hit the enter key. As you can see we get a number, 43638. This is because behind the scenes, excel calculates dates by numbers.
So, to change this, we left click on cell C2, then go down and left click on format cells. In the pop up box, left click on Date, then left click on ok, and we have the date formatted in the cell.
You can highlight and format any future answer cells as you see I am doing on the screen.
Now, in cell C3, I have the formula input, but the months is negative 4. I hit the enter key, and we get 10/31/2018, which is the last day of the month, 4 months in the past.
And, you can also manually input the number of months in the function, as you see here. I hit enter, and we get our answer.
Chapters/Timestamps
0:00 Example set up
0:20 How to find exact date n months in the future in excel
0:55 How to format cells to date
1:35 How to manually input number of months
Негізгі бет How To Calculate (Find) The Date N Months In The Future Or Past From A Given Date In Excel Explained
Пікірлер