Excel may return a serial number instead of a date; because it is stored thus in the backend. Learn how to convert Serial Number to Date.

Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel.