May 27 2020 08:42 AM
@KARINDEBEER I suspect that the column where you have the RAND() function is formatted as DATE and you get 1 January 1990 in all cells.
Format as GENERAL and you'll see numbers between 0 and 1.
May 27 2020 08:45 AM
Its is possible that The cell in which =RAND() is format as long or short date. You need to convert it to numbers or general Format.