Datevalue Formula In Excel

Datevalue formula converts a given date in Numeric value . The DATEVALUE formula in Excel converts a date that is stored as text to a serial number that Excel recognizes as a date. For example, the formula =DATEVALUE"1/1/2008" returns 39448, the serial number of the date 1/1/2008. Remember, though, that your computer's system date setting may cause the results of a DATEVALUE formula in Excel to vary from this example The DATEVALUE formula in Excel is helpful in cases where a worksheet contains dates in a text format that you want to filter, sort, or format as dates, or use in date calculations. The training excel file shown in the video is available for free download at 10 Most Used Formulas MS Excel

Related Videos