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.
Gives the age of person, 2 between today's date and the birthdate in A2. This example uses the YEAR function and NOW function. If cell doesn't display as a number, make sure it is formatted as a number or General. Learn how to format a cell as a number or date. =YEAR(NOW())-1960.