# Generate Random Date (RANDBETWEEN - Excel)

**URL:** <https://community.easymorph.com/t/generate-random-date-randbetween-excel/2173>\
**Category:** General Q&A\
**Created:** [October 18, 2020, 2:02am UTC](https://community.easymorph.com/t/generate-random-date-randbetween-excel/2173 "2020-10-18T02:02:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rykie](https://community.easymorph.com/user_avatar/community.easymorph.com/rykie/32/1255_2.png) [@Rykie](https://community.easymorph.com/u/Rykie)\
**Post date:** [October 18, 2020, 2:02am UTC](https://community.easymorph.com/t/generate-random-date-randbetween-excel/2173/1 "2020-10-18T02:02:30Z")

</div>

HI

Can anyone help me with this excel formula in Easymorph?

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

Thanks

---

<div class="post-metadata">

**Author:** ![dgudkov](https://community.easymorph.com/user_avatar/community.easymorph.com/dgudkov/32/5_2.png) [@dgudkov](https://community.easymorph.com/u/dgudkov)\
**Post date:** [October 18, 2020, 9:46am UTC](https://community.easymorph.com/t/generate-random-date-randbetween-excel/2173/2 "2020-10-18T09:46:23Z")

</div>

```
 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)

```

---

<div class="post-metadata">

**Author:** ![Rykie](https://community.easymorph.com/user_avatar/community.easymorph.com/rykie/32/1255_2.png) [@Rykie](https://community.easymorph.com/u/Rykie)\
**Post date:** [October 18, 2020, 2:46pm UTC](https://community.easymorph.com/t/generate-random-date-randbetween-excel/2173/3 "2020-10-18T14:46:51Z")

</div>

Excellent.

Thank you, Dmitry