skip to Main Content

Random Date Generator

5.0 (3 reviews)

This Random Date Generator Excel Template will provide random calendar dates according to the parameters such as start date, end date, holidays you set.

Learn more about License Types

Someka refunds icon


Someka one time payment icon


Someka direct download icon



We all need to plan our work, sometimes it is about planning a weekly meeting or splitting our workdays for some specific tasks or milestones of a project. But a simple calendar will not tell us how many days we have between the start and the due day of a project. We need to go week by week or month by month and calculate it. In any of these cases, our Random Date Generator template is coming to help you out.


Random Date Generator Features:

  • Generate Dates: You can generate a list of dates either random or in order with specific rules set by you. You can even exclude some of the specific days like official holidays or your vacation. By Random Date Generator tool, you will be able to create a list of dates even up to 1000. This feature will help you to format those dates according to your standard.


  • Dates Calculator:  In this section, you can count how many days you have left until your deadline or how long it took to complete some of your previous projects. Random Date Generator template helps you to plan your project. It is good to know how many days you have. Sometimes our work schedule also includes Saturdays so we can also include them in the working days. The useful option is excluding our custom holidays.


By specifying a date, you can also learn this date’s certain week number, name of the day, and which day of the year that this.


  • Custom Holidays List: You can note all of the holidays in this section. After you add your holiday dates inside this list, the calculation of your workdays will be more accurate. You don’t have to cancel or delay your work duration, because you have already encountered your off days with this tool.

Random Date Generator Features Summary:

  • Generate random dates in Excel
  • Informational notes included
  • No installation needed. Ready to use.
  • Works both on Mac and Windows
  • Compatible with Excel 2010 and later versions

This Random Date Generator is ready-to-use Excel Template and provided as-is. If you need customization on your reports or need more complex templates, please refer to our custom services.


Watch the video below to see the template in action! Presentantation also includes usage notes, explanations and tips & tricks about the template.



3 reviews for Random Date Generator

  1. Sayed Mousa

    Excellent sheet

  2. Wahdat

    It is very useful

  3. Michael

    Hi, I have a project and I need to prepare a simulation with random dates to get results. I found a way to generate it. But, I have to exclude some specific dates and this requires additional effort. But, thanks to you this tool helped me a lot. It is just free but it saved my hours with days to include or exclude section. thanks guys!

    • Someka

      Hi Michael, we are happy to hear that this tool is useful to you!

      Best regards,

Leave a customer review

Only verified users who have downloaded and used the template may leave a review.