tag:blogger.com,1999:blog-3794737577784583819.post4167224885655271015..comments2023-10-25T04:38:36.360-07:00Comments on Excel Enthusiasts: Using the RAND FunctionBob DeLaMartrehttp://www.blogger.com/profile/03761089085420930697noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-3794737577784583819.post-69255220182590476852011-08-30T04:00:41.178-07:002011-08-30T04:00:41.178-07:00Thank You !!
Another application could be to be g...Thank You !!<br /><br />Another application could be to be generate random dates. The function for the same is =TEXT(A2+INT(RANDBETWEEN(0,30)),"mm/dd/yyyy") to generate random dates between A2 and A2+30 days(where A2 is the start date)<br /><br />Or you could use the function to run lucky drawsSiteAdminhttps://www.blogger.com/profile/12372678300323368301noreply@blogger.com