How can I find out the exact age?
The method of calculating age involves the comparison of a persons date of birth with the date on which the age needs to be calculated. The date of birth is subtracted from the given date, which gives the age of the person. Age = Given date - Date of birth.
How do you calculate someones age using Excel?
How to calculate age in ExcelIn the third cell, for us its C2, enter the following formula: =DATEDIF(A2, B2, “y”). You can also get a persons age without entering todays date in the second cell. The final, most specific measurement that you can make is a persons age, including months and days.More items •Jul 11, 2021
How can I find someones age without asking?
Here are 15 ways to find out how old your date really is without actually asking:Stalk him on social media. Social media is always a go-to. Ask mutual friends. Check LinkedIn. Google him. Search public records and data. Analyze his name. Bring up technology. Discuss school memories.More items •Nov 18, 2016
How do you trick someone into telling you your birthday?
Add the day of your birth (eg, if your birthday was 29 February, youd multiply by 29) Add 3. Multiply by 11. Subtract the month of your birth (eg 2)
How do I enable the Datedif function in Excel?
Using The DateDif Function in Microsoft ExcelHave you ever needed to work out the difference between two dates? There are a couple of ways to insert a function into an Excel Worksheet.This will bring up the Insert Function Window.Search for the Function you want to use, and select go.More items •May 24, 2021