Hi,
I'd like to generate date with
but:Please Login or Register to view this content.
1. days are generated
2. months always 01
3. how to generate years, i.e. from 2000 to 2015
all advices are very welcome.
sandy
Hi,
I'd like to generate date with
but:Please Login or Register to view this content.
1. days are generated
2. months always 01
3. how to generate years, i.e. from 2000 to 2015
all advices are very welcome.
sandy
Last edited by sandy666; 03-01-2015 at 03:57 PM.
For random dates between 1/1/2000 & 12/31/2015, use:
Please Login or Register to view this content.
Ben Van Johnson
Thanks for answer protonLeah,
but =RANDBETWEEN("1/1/2000","12/31/2015") => #VALUE
Try this..
Formula:Please Login or Register to view this content.
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
It works on my xl 2007 version(??)
Working great Debraj Roy,
Many thanksPlease Login or Register to view this content.
this is a solution
1st : date value is random between 1/1/2000 and 31/12/2015
Formula:Please Login or Register to view this content.
or
2nd: (convert to text)
Formula:Please Login or Register to view this content.
Best regard, -)iger-/iger
If you are pleased with a solution mark your post SOLVED.
ProtonLeah,
I don't have ex2007 and don't know why on ex2013 result is #VALUE
anyway thank you for help
tigertiger,
second option isn't good because definitions of yy mm dd are different in different languages. It cannot be changed by excel engine because there are " ".
EDIt:
It's working if I use it like: =RANDBETWEEN("36526","42369") and format cell as DATE
thank you
Last edited by sandy666; 03-01-2015 at 04:29 PM.
Thank you all gurus,
I got solution SOLVED
tigertiger,
read my answer to you above in EDIT
thank you
So, I think the best and much shorter will be
and format cells to date format.Please Login or Register to view this content.
Anyway I got some ideas and solutions
Thank you all
Yes, that's right
Even with the Month and Day parts swapped, i.e. with this version:
=DATE(RANDBETWEEN(2000,2015),RANDBETWEEN(1,12),RANDBETWEEN(1,31))
You may get dates in the correct range but some dates would be more likely than others, e.g.
=DATE(2015,3,1)=DATE(2015,2,29)
I would use tigertiger's suggestion
=RANDBETWEEN(DATE(2000,1,1),DATE(2015,12,31))
That version will work correctly, with an even distribution, regardless of your date system or regional settings.
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks