Dreevoo.com | Online Learning and Knowledge Sharing
 
Home | Programs | Microsoft Office | Microsoft Excel | Calculate your retirement date with Excel
Guest
Click to view your profile
Topics
Programs
Languages
Recipes
Home
Shortcuts
 
 

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.

 
  Author: mat | Version: 2010 | 23rd April 2013 |  
 
 
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.

 
 
10.
 

And here's the exact date of retirement.

Now use the NETWORK days function to calculate how many days or working days you got left until the important event. To make the task easier, you can go to the how to calculate working days between two dates tutorial.

 
 
 
   
  Please login to post a comment
  Click to open user profile  
marywilliams, 10th Sep 2024, 10:38 AM
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!
 
 
  Click to open user profile  
coniemules, 22nd Oct 2024, 10:24 AM
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
 
 
  Click to open user profile  
Gregory12, 22nd Oct 2024, 10:51 AM
Thank you for taking the time to write and share the article! https://papalouie.io
 
 
  Click to open user profile  
ivestevedore, 21st Nov 2024, 2:57 AM
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
 
 
  Click to open user profile  
ivestevedore, 21st Nov 2024, 2:57 AM
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
 
 
  Click to open user profile  
Rosariokris, 30th Nov 2024, 9:42 AM
Thanks for posting such a wonderful blog or article. It contains wonderful and helpful information. Keep up the excellent work! https://fnfmods.io

 
   
 
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO