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.

How to calculate positions (1st,2nd,3rd...) in Excel 6 Unable to change date format in Excel 39 Excel - IF function with multiple words 14 How to convert number into text in Excel 9 If a cell contains ...

It's easy to return random values in Microsoft Excel, but returning random letters might leave you scratching your head. Fortunately, you only need two functions.

Specifying the conditional count of a value sounds like a daunting task, but two Excel functions make quick work of this challenge.