Demo_生成随机日期和时间

随机日期时间

=TEXT(RANDBETWEEN("2017-01-28","2017-01-30")+RANDBETWEEN(VALUE("08:21:01")*10^6,VALUE("18:00:57")*10^6)%%%,"e-mm-dd hh:mm:ss")

随机日期

=RANDBETWEEN(DATE(2019, 1, 1),DATE(2019, 10, 20))