Generating Random Future Dates,Time & Datetime in Excel

Crispo Mwangi | 25-Jun-16 | Leave a Comment

In this article I will show you how to generate random future Dates, Time &Datetime in excel using RAND(), RANDBETWEEN and WORKDAY.INTL functions. RANDBETWEEN function returns a random integer in a range of integers. = RANDBETWEEN(bottom, top) →→bottom(smallest integer) & top (largest integer) And since excel stores date as sequential serial numbers, we can use RANDBETWEEN to generate […]