Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel Random Date or Random Date and Time – 2524

Posted on by Annie D

How to generate random dates in Excel.
How to generate random date and time in Excel.

Table of Contents
(0:00) Welcome
(0:34) Random Date in Excel
(2:38) Random Time in Excel
(3:01) RandomTime During the Workday in Excel
(3:58) Random Time to nearest quarter hour
(4:45) Random Date /Time in Excel
(5:36) Random Weekday in 2025 in Excel
(6:44) Random Weekday No Holidays in Excel
(7:45) Randomly Choose a Monday or Thursday in Excel
(9:19) Randomly Choose particular weekdays in Excel
(10:35) Wrap-Up

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.

MrExcel.comMon, October 24, 2022 2:36pm