Skip to main content

Featured Post

Boost Your PC Speed by Using SSD

In short you can explain an SSD (Solid State Drive) as modern HDD (Hard Disk Drive). What's the difference then? Maybe the functions are almost same but there are some big differences between the two. Go through the post to clear the concept . . .

What's an SSD A solid state drive or SSD is a storage device that uses non volatile flash memory along with necessary controller and chipset to store the data. It's somewhat like RAM, but unlike RAM it can store data for a long period of time. 
An SSD drive is considered to be more durable and stable in that sense - There is no moving parts i.e. platters, spindle, R/W head etc. which are available in traditional HDD.  

Advantages of SSD over HDD If you use SSD as your primary boot device instead of HDD then you may get the following advantages -  Faster performanceLower power consumptionBetter vibration resistanceLower heat No noiseIn short we can say, SSD is more durable and stable than traditional HDD. 

After installing SSD, you will…

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!


Comments