Question

which function return serial number of current system date​

Answer 1

Answer:

The DATEVALUE function 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 datecalculations. To view a date serial number as a date, you must apply a dateformat to the cell.

Answer 2

The DATEVALUE function 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. To view a date serial number as a date, you must apply a date format to the cell.

Hope it helps...