Skip to main content

Age Calculator by Microsoft Excel !!


Microsoft Excel Age Calculator


Often you may need to calculate your age. Or someone may ask you to calculate his/ her date. And sometimes you may need to calculate the difference between two dates. There are many third party tools (small software) to calculate the difference between the two days. 


If you're using Windows 7/ 8 then you don't need any other tool to calculate the difference between two dates. Because Windows 7 and 8 has a nice calculator. It allows you to calculate age or date difference. 

To calculate a date using Windows 7/8 calculator- 
  1. Press Start + R > type calc > hit Enter. 
  2. Now go to the View menu and choose Date Calculation. 
  3. Now enter the From date and To date and hit on Calculate button. 


But my today's discussion is not this one. Today I'm gonna show you how to calculate the age or the difference between two dates using Microsoft Excel! You just need to download a file and then open it. Download the file from the link below:


Download


This is a zip folder. After downloading the folder, first you need to unzip it. There are 3 files:
  • A Read Me file
  • An xls file for Office 97-2003 users
  • An xlsx file for Office 2007 and 10 users
Open the file that is compatible with your version of Microsoft Excel. After opening the file you will see some text as showing in the image above. Now do the following:
  1. Input current date in the day, month and year column.
  2. Input your birth date or the date from where you want to calculate in the day, month and year column.
  3. Now you get the difference or your age in the Age row. 


Remember: Formulas used in this file for calculation are hidden. Never try to change it unless you're capable. If you make any mistake then it will not show you the correct result. If you wanna change the formulas, first you have to keep a back up copy of the file. 


Hopefully this file will be very useful for you. If you wanna know about something or expect something from us, just leave a comment with your feedback/ opinion. 


Thanks for visiting Marks PC Solution . . . 


Stay with Marks PC Solution to get more interesting IT topics!


Labels:

Comments

Post a Comment

Popular posts from this blog

GTA San Andreas Cheat Code (PDF)

After Vice City, San Andreas is the most popular game released by Grand Theft Auto (GTA). Usually GTA releases role playing game. San Andreas is such a game where you can act like a person. You can do everything. You have to take part in missions and complete them.  To make your missions easier, there are lots of cheat codes. If you can properly apply these codes, the tough parts of the game will be easier. Cheat codes are somewhat like keyboard shortcuts of computer programs.  I've shared 63 cheat codes below. There were more cheat codes in my collection, but I've omitted the less important cheats. Effects or result of the cheats are on the left side, and the codes are on the right side.  You can copy the following codes in your PC. And for your convenience, I've also uploaded a PDF file of these codes. You will find the download link at the bottom.  Effect Cheat Code Adrenaline Mode MUNASEF All Cars Explode ALL...
8 comments
Read more

How to Change IP Address on Windows 10 (Easy Way)

    In fact this is not a very difficult task. But in case of emergency you may not find the right option and this happened in my office few days ago! I solved the problem myself and decided to write a note for you at my site . . .   Changing IP Address on Windows 10 Simply move your mouse pointer at the bottom right corner and make a click on network icon > choose Open Network and Internet settings. Follow the image below -    After clicking on this option you will get the following dialogue box. Here you should notice Ethernet properties. Click on it.   Now you will get another screen as below. Here you will get several options. But our concern is IP settings and Properties . If wanna view your IP details then look at the Properties. If you need to change it then hit on the Edit button.    After clicking on the Edit button you will have two options i.e. Automatic (DHCP) & Manual.    In order the change the IP you should choose ...
Post a Comment
Read more

Office 2016 Activator (KMSPico 10.1.5)

It's been couple of months after the release of final version of Microsoft Office 2016. And maybe you're tired of finding for a working activator for this version. Today I'm gonna share Office 2016 activator with you - no more waiting!! About the Activator   Name: KMSPico 10.1.5 File Size: 3 MB (Approx) File Type: Zipped Folder 100% Neat & Clean - No virus! Activating Capacity . . . KMSPico 10.1.5 is successfully leading the KMS world for last few months. If everything is okay, success rate is 100%. This tool has been tested and verified by Marks PC Solution. With this tool, you can activate -  Office 2016, 2013 & 2010 Windows 10, 8.1 & 8 Hopefully this version will work for both 32 bit & 64 bit versions of Windows. Installing Office 2016 Collect/ Download Office 2016 Professional Plus from Microsoft or somewhere else. Install it as trial version without any key. Use the follow...
187 comments
Read more