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.
Example: Calculate Your Current Age with DATEDIF. 1  Enter your birth date into cell E1 of the worksheet. 2  Type =TODAY( ) into cell E2. 3  Type the following formula into cell E3. = DATEDIF (E1, TODAY( ),Y) &  Years,  & DATEDIF (E1, TODAY( ),YM) &  Months, . 1  Press the ENTER key on the keyboard.