HI
Can anyone help me with this excel formula in Easymorph?
=RANDBETWEEN(TODAY(),TODAY()+365)
Thanks
HI
Can anyone help me with this excel formula in Easymorph?
=RANDBETWEEN(TODAY(),TODAY()+365)
Thanks
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)
Excellent.
Thank you, Dmitry