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
   
 
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO