2. How to Generate Random Number, Date, Text in Ms-Excel - #1MinuteSnippets

Description:
Follow Our Telegram Group for just learning: https://t.me/joinchat/Rw3yMxhJRRT6zIAoZJ8y3w

How to Randomly Generate Numbers, Dates, and Text.

I have used RANDBETWEEN(bottom, top) function for all the three cases

???? Random Number is
Practically useful to select the sample out of invoice numbers

???? Random Date is
Practically useful to generate random dates in case of building any invoices (for Tax Purpose ????).

???? Random Text is
Practically useful to build random reference numbers along with number combinations.

I have used CHAR() function. This function converts the Code to Character as per ASCII.