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.