randbetween date?

[Jazzzola324]

I want to generate random dates between two dates. I used the formula =RANDBETWEEN(DATE(2014,5,6),DATE(2016,4,23)). Then the number 41918 appears in the cell. What am I missing?

 

[lrobbo314]

The answer is correct, you just need to format the cell as a date.

 

[Rick Rothstein]

Excel stores dates as integers... the number of days offset from (and including) January 1, 1900. Your number is the numerical offset for October 6, 2014. To see this, simply format the cell to show the date format you want.