I recently needed to generate some random time values in Numbers that included both a random date, and a random time of day. It isn't immediately obvious how to do this, so I thought I'd share what I came up with. Here's the function: =DATE(RANDBETWEEN(2000,2021),RANDBETWEEN(1,12),RANDBETWEEN(1,28))+DURATION(0,0,RANDBETWEEN(8,20),RANDBETWEEN(0,59),0,0)
Note: This is Club MacMost exclusive content. To view this video click the thumbnail below to go to the post as Patreon.com. Once there you will be able to view the video as long as you are logged into your Patreon account and a current supporter of MacMost at the "Club MacMost" or higher level.