In addition to the function name the Function statement usually specifies one or more arguments. The existing date is in cell E2 so we need to write this formula in a way that extracts the year month and day from E2 but also adds 10 to the year value. Discover how functions in Excel help you save time.
In this example were wanting to see the date thats 10 years past an existing date.
1 Count and Sum. In Excel Online this is the method you must use. TEXT is available in all versions of Excel. Right-click anywhere in the Excel ribbon.