How to make Excel automatically generate dates

Excel automatically generate date I want to automatically generate a date in a column (no more than one day of the set), there's no way to do that. First, set the cell format for this column to date format, and if you want to set the date to be between 2000-1-1 and 2100-1-1, enter the following formula in this column: =int (RAND () * (73051-36526) +36526) to set a different time period, simply modify the values in the formula to
What is the law of the date and number you want?
From the day of 1900-1-1 to the 1th day, the day of 2000-1-1 is just the No. 36526 day.