Generate Random Date (RANDBETWEEN - Excel)

1

HI

Can anyone help me with this excel formula in Easymorph?

=RANDBETWEEN(TODAY(),TODAY()+365)

Thanks

2 
 today() + round(random()*365,0)

If you want to be a bit more pedantic and account for leap years, then

LET td = today()
td + round(random()*(addyears(td,1) - td),0)
3

Excellent.

Thank you, Dmitry