All articles with 'edate()' Tag
Add any number of days, months or years to a date with this simple trick
Let’s say you have a date in A1 and want to find out future date after 2 years, 4 months and 9 days.
Here are a few formulas you can try.
- =A1 + DATE(2,4,9)
- =EDATE(A1, 2*12+4) + 9
- =A1 + 2*365 + 4*30 + 9
Surprisingly, each formula gives a different result! So which one should you use?
Continue »Today, let’s travel in time. Pack your photon ray guns, extra underwear, buckle your seat belts and open Excel!
Of course, we are not going to travel in time. (Come to think of it, we are going to travel in time. By the time you finish reading this, you would have traveled a few minutes)
We are going to learn how to travel in time when using Excel. In simple terms, you are going to learn how to move forward or backward in time using Excel formulas.
So are you ready to hit the warp speed? Let’s beam up our Excel time machine.
Continue »