Skip to main content

Posts

Showing posts from March, 2011

New Article

How to SUM by matching partial text in Excel

Age Calculator

Today I’m going to share with you an interesting thing which is very much helpful to job seekers. I have seen in many website that, they require the age as on a specific date. Well this is a problem to almost everyone to find the exact days of their age. To solve this problem I made a simple Age Calculator in MS-Excel 2013. Well it will also work (hope so) in MS-Excel 2003 or later version. What is it? This is a calculator which can able to calculate the exact difference from provided two different dates. You can use it as an age calculator, as days remaining from final exam etc. How to do it? The simple DatedIF function has applied for this purpose. The DatedIF function is available in Excel 2003 and later version. The function is: =DatedIF(Starting_Date,Ending_Date,"YMD") Form Design Open a new sheet in Excel and design the age calculator as given below. Make sure that B5 and C5 cell is not in Text format. Text format not supports calculation. That