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 ...
Learn Microsoft Excel with step by step tutorials including charts, formulas, functions, Power BI, Excel VBA for beginners.