About EasyMorph Tutorials & Examples Web-help

Generate Random Date (RANDBETWEEN - Excel)

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

To learn more about EasyMorph visit easymorph.com.