Average monthly weather in Sorrento, Italy. What's the best time to travel to Sorrento in Italy? 1  The months May, June, September and October have nice weather with a good average temperature.  On average, the warmest month(s) are June, July and August.
So does it in Excel. Step 1: Enter current date in a blank cell, such as 2016/4/7 in Cell B2. Step 2: In another blank cell (says cell C2), enter the formula =INT((B2-A2)/365), and press the Enter key. Method B: Convert birthdate to age with DATEDIF function. Some would like to apply the DATEDIF function to calculate the age. Enter the formula =DATEDIF(A2,NOW(),y) in a blank cell, it calculates the age immediately after pressing the Enter key. Method C: Convert birthdate to age with ROUNDDOWN function. Another function to convert the birth date to age is =ROUNDDOWN(YEARFRAC(A2, TODAY(), 1), 0), which will figure out a standard age, such as 27. Method D: Convert birthdate to exact age with DATEDIF function.
How to Convert DOB to Age in MS Excel. Microsoft Excel provides a function that displays a person's age based on his date of birth. In your business, this function can help you keep track of your workers' ages in a spreadsheet; you'll need to know this information, for example, if you are shopping for new health insurance coverage for your company. Every time you open the spreadsheet, Excel will update the Age cells based on the current date. To calculate the age, the DATEDIF function, set to check year, determines the number of years between the date in the DOB cell and the current date. Open the spreadsheet that contains the DOB information you want to convert. Insert a blank column next to the column that contains the DOB data, if needed.