![]() Type =DATEDIF(XX, TODAY(), “Y”) then press Enter on your keyboard.Type a birthdate into a cell in the format MM/DD/YYYY (if in the United States) or in the format DD/MM/YYYY if your country uses that format.Quick Summary – How to Determine an Age from a Birthdate in Excel 2013 Our tutorial below will show you the formula that lets you take a birthdate and compare it to the current date to see how old someone is. ![]() One other thing that you can do is calculate someone’s age based on a birthdate that’s been entered into a cell. You’ve probably had to add up values in Excel before, or maybe even calculate an average, but there is even more that you can do with numerical values that you have entered into a spreadsheet. Excel has a lot of tools that can help you calculate values based on data that you’ve entered. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |