formatting question

[mklangelo]

I used =RANDOMBETWEEN to generate a set of dates and decided to change one of the cells to "Number" format and that cell is highlighted. When I switch that cell to date format, it shows the date again. How does, 42165 correlate to 6/10/2015?

Thanks!

 

[pecoflyer]

Might I suggest you search the Net for how Excel treats dates ? There are lots of info on this matter

 

[PaulF]

Date are a serial number starting with 1 = 1/1/1900 so 42,165 dates after 1/1/1900 = 6/10/2015

 

[mklangelo]

Thanks!