Toggle Help Topics Menu >

Fill Range with Random Dates

Fills a range of cells with a set of random dates.

Form Fields

  • Range: Select the range to fill. (This field is preset with the selected range when the form is opened.)
  • Distribution: Select a Uniform or Normal (Gaussian) distribution.
  • Start date: The lower end of the date range.
  • End date: The upper end of the date range.
  • Date format: A dropdown list of common date formats. See Date Formats for details.
  • Date separator: choose from dash, slash, dot, or space ("-", "/", ".", or " ").
  • Use localized day and month names: Uses the built-in Excel localized names based on your system settings.

Note: This uses the Box-Muller transformation for generating the Normal distribution.