Datevalue Formula in Excel Hindi

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.

Related Videos