|
|
|
|
Calculate your retirement date with Excel
If you know how many years or months you got left until the retirement or any other event or project in your life, Excel can return you the exact date and the number of days left to reach it.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1.
|
|
|
Create a similar sheet to mine and enter the date when you started your job.
Click the cell next to Retirement.
|
|
|
2.
|
|
|
In the menu click Formulas and Date & Time ...
|
|
|
3.
|
|
|
From the drop down menu choose EDATE function.
|
|
|
4.
|
|
|
As the Function Arguments windows shows up, click the cell where you entered the starting date ...
|
|
|
5.
|
|
|
... in the Months field enter the number of months until the retirement.
For example, if you know you need to work 40 years until you can retire, then enter 40*12, where 12 is number of months in a year.
Click OK.
|
|
|
6.
|
|
|
Now you probably got some number but it doesn't tell you a lot. We need to convert it into an actual date.
|
|
|
7.
|
|
|
In the menu click Home ...
|
|
|
8.
|
|
|
... click the Number Format field ...
|
|
|
9.
|
|
|
... and choose Short Date.
You can choose the Long Date as well if you wish so.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Using these simple Excel formulas, you can keep track of how much time you have left until retirement or any important event in your life. You can access https://geometrydashlite.online because this can help you plan better and stay motivated as you approach your goals! |
|
|
|
|
|
|
|
|
Tap Road is a fantastic game! The simple controls make it easy to pick up, but the challenging obstacles keep me coming back for more. https://1games.io/tap-road |
|
|
|
|
|
|
|
|
Geometry Dash is an app store game available on 2013. The game centered on a cube who had to leap over hurdles to reach the finish of every level! At first it was solely levels produced by RobTop, the game's designer. https://bitlifesimulator.io |
|
|
|
|
|
|
|
|
Geometry Dash is an app store game available on 2013. The game centered on a cube who had to leap over hurdles to reach the finish of every level! At first it was solely levels produced by RobTop, the game's designer. https://bitlifesimulator.io |
|
|
|
|
|
|
|
|
Thanks for posting such a wonderful blog or article. It contains wonderful and helpful information. Keep up the excellent work! https://fnfmods.io
|
|
|
|
|