{"id":3762,"date":"2016-07-19T19:27:15","date_gmt":"2016-07-19T17:27:15","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=3762"},"modified":"2024-03-24T14:09:45","modified_gmt":"2024-03-24T13:09:45","slug":"randbetween-function-for-dates","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/randbetween-function-for-dates\/","title":{"rendered":"RANDBETWEEN Function for Excel Dates"},"content":{"rendered":"

What does it do?<\/strong><\/em><\/p>\n

Generates random dates, in between a start date and an end date<\/p>\n

Formula breakdown:<\/strong><\/em><\/p>\n

=RANDBETWEEN(bottom,<\/span> top<\/span><\/span>)<\/p>\n

What it means:<\/strong><\/em><\/p>\n

=RANDBETWEEN(starting date for random date generation<\/span>,<\/span> end\u00a0date for random date generation<\/span><\/span>)<\/span><\/p>\n

\n

 <\/p>\n

If you need to create a quick sample data set of Dates<\/em>, the RANDBETWEEN<\/strong> function<\/a> in Excel is very handy to use.<\/p>\n

All you need is to provide a start Date and an end Date. Then the function will immediately generate a random Date following that Date range you have provided.<\/p>\n

This is how it is done below (go to the bottom of the page if you want to see the animated gif tutorial):
\n