Excel has over 475 formulas in its Functions Library, but we've selected the most popular, ... Copy the numbers from the spreadsheet in figure 13, or download the full workbook (link below). 2.

DATEVALUE converts the above formula into an Excel date, which is necessary if you plan to use this date for calculations. This one is easy: Select DATEVALUE from the formula list.