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  
Mahi01, 17th Dec 2020, 7:08 AM
To learn more about how to recover Apple ID visit : [url=https://sites.google.com/site/applesidre....apple.com/recovery[/url]] without phone number, you can click here -[url=https://sites.google.com/site/recoveryap....apple.com/recover[/url]] . And yes, you can recover Apple ID without phone number.The fastest and easiest way to reset your password is an [url=https://sites.google.com/site/applecomre....apple.com/recover[/url]] device. Which is designed to bring you back to your Apple ID account. You can visit [url=https://sites.google.com/site/applecomsr....apple.com/recover[/url]] for more information.
 
 
  Click to open user profile  
Mahi01, 21st Dec 2020, 11:50 AM
To setup and install your 123 HP printer go to https://sites.google.com/site/setuphphpp.... for mac . For installation of drivers, seek help immediately from the website https://sites.google.com/site/httpsetupf.... . We’ll help you download the right HP printer software and drivers.Be sure to install cartridges, load paper and power on the printer. Download the 123 hp printer setup to get the recommended software for your printer. We will help you download the correct HP printer software and drivers. Which includes Windows, MacOS, iOS and Android. You can then install your https://sites.google.com/site/setup123hp.... . For installation of drives, you can take help of our website 123 hp printer setup.
To set up your HP printer, download and install https://sites.google.com/site/123printer.... from here. HP printers are compact and durable, ready to deal with your print needs. Set your printer setup from HP to begin. The entire data referenced in this regard is straightforward and simple.Be sure to install cartridges, load paper and power on the printer. Download the https://sites.google.com/site/enterkeyco.... to get the recommended software for your printer. We will help you download the correct HP printer software and drivers. Which includes Windows, MacOS, iOS and Android. You can then install your https://sites.google.com/site/setuphphpp.... . For installation of drives, you can take help of our website 123 hp printer setup.

 
 
  Click to open user profile  
Mahi01, 21st Dec 2020, 11:50 AM
To setup and install your 123 HP printer go to https://sites.google.com/site/setuphphpp.... for mac . For installation of drivers, seek help immediately from the website https://sites.google.com/site/httpsetupf.... . We’ll help you download the right HP printer software and drivers.Be sure to install cartridges, load paper and power on the printer. Download the 123 hp printer setup to get the recommended software for your printer. We will help you download the correct HP printer software and drivers. Which includes Windows, MacOS, iOS and Android. You can then install your https://sites.google.com/site/setup123hp.... . For installation of drives, you can take help of our website 123 hp printer setup.
To set up your HP printer, download and install https://sites.google.com/site/123printer.... from here. HP printers are compact and durable, ready to deal with your print needs. Set your printer setup from HP to begin. The entire data referenced in this regard is straightforward and simple.Be sure to install cartridges, load paper and power on the printer. Download the https://sites.google.com/site/enterkeyco.... to get the recommended software for your printer. We will help you download the correct HP printer software and drivers. Which includes Windows, MacOS, iOS and Android. You can then install your https://sites.google.com/site/setuphphpp.... . For installation of drives, you can take help of our website 123 hp printer setup.

 
 
  Click to open user profile  
Mahi01, 21st Dec 2020, 11:52 AM
Be sure to install cartridges, load paper and power on the printer. Download the https://sites.google.com/site/setup123hp.... to get the recommended software for your printer. We will help you download the correct HP printer software and drivers. Which includes Windows, MacOS, iOS and Android. You can then install your https://sites.google.com/site/123printer.... . For installation of drives, you can take help of our website 123 hp printer setup.A printer driver is software that your computer uses to talk to a physical printer, which may be connected to your computer or another computer on your network. You can download printer drivers and software from our website. You can visit this site to install https://sites.google.com/site/httpsetupf.... . you can take help from our website 123 hp printer setup.

 
 
  Click to open user profile  
Mahi01, 21st Dec 2020, 11:54 AM
A printer driver is software that your computer uses to talk to a physical printer, which may be connected to your computer or another computer on your network. You can download printer drivers and software from our website. You can visit https://sites.google.com/site/installhpp.... this site to install printer setup. you can take help from our website 123 hp printer setup.Be sure to install cartridges, load paper and power on the printer. Download the https://sites.google.com/site/hpprinterw.... to get the recommended software for your printer. We will help you download the correct HP printer software and drivers. Which includes Windows, MacOS, iOS and Android. You can then install your https://sites.google.com/site/123hpcompr.... . For installation of drives, you can take help of our website 123 hp printer setup.
 
 
  Click to open user profile  
Mahi01, 21st Dec 2020, 11:54 AM
To setup and install your 123 HP printer go to https://sites.google.com/site/howtosetup.... for mac . For installation of drivers, seek help immediately from the website https://sites.google.com/site/installing.... .Install 123 HP Printer Driver, Software Downloads How to install a local printer in computer or mobile devices. Hit a Start butt on in your computing devices and click a control panel on a Start menu.visit here : https://sites.google.com/site/setupwirel....

 
 
  Click to open user profile  
Mahi01, 21st Dec 2020, 11:54 AM
To setup and install your 123 HP printer go to https://sites.google.com/site/howtosetup.... for mac . For installation of drivers, seek help immediately from the website https://sites.google.com/site/installing.... .Install 123 HP Printer Driver, Software Downloads How to install a local printer in computer or mobile devices. Hit a Start butt on in your computing devices and click a control panel on a Start menu.visit here : https://sites.google.com/site/setupwirel....

 
 
  Click to open user profile  
Mahi01, 21st Dec 2020, 11:55 AM
Install https://sites.google.com/site/installhpp.... , Software Downloads How to install a local printer in computer or mobile devices. Hit a Start button in your computing devices and click a control panel on a Start menu.Be sure to install cartridges, load paper and power on the printer. Download the https://sites.google.com/site/setupinsta.... to get the recommended software for your printer. We will help you download the correct HP printer software and drivers. Which includes Windows, MacOS, iOS and Android. You can then install your https://sites.google.com/site/123hpcom12.... . For installation of drives, you can take help of our website 123 hp printer setup.

 
 
  Click to open user profile  
Mahi01, 21st Dec 2020, 11:57 AM
A printer driver is software that your computer uses to talk to a physical printer, which may be connected to your computer or another computer on your network. You can download printer drivers and software from our website. You can visit this site to install https://sites.google.com/site/123hpsetup.... . you can take help from our website https://sites.google.com/site/installhpp.... .To setup and install your 123 HP printer go to https://sites.google.com/site/123hpsetup.... for mac . For installation of drivers, seek help immediately from the website 123.hp.com/setup.

 
 
  Click to open user profile  
Mahi01, 21st Dec 2020, 11:58 AM
To set up your HP printer, download and install https://sites.google.com/site/hp123setup.... from here. HP printers are compact and durable, ready to deal with your print needs. Set your printer setup from HP to begin. The entire data referenced in this regard is straightforward and simple.To setup and install your 123 HP printer go to https://sites.google.com/site/123hpsetup.... for mac . For installation of drivers, seek help immediately from the website https://sites.google.com/site/hpprinter1.... . We’ll help you download the right HP printer software and drivers.

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