Good idea, But, it would be easier if write one formula between the general value of 1st Jan. 20000 and 31st Dec. 2020, then change the format of the cell to be date General number of 1st Jan 2000 is 36526 and of 31st Dec 2020 is 44196 So the formula would be : =RANDBETWEEN(36256,44196) now the format cell to be changed date Thanks Maki S. Hussain Baghdad-Iraq
I'm sure you could make a more advanced formula or a spreadsheet setup that would account for that issue - I have made large templates for this in the past - but I've found quick formulas like this are ok for many scenarios.
Good idea,
But, it would be easier if write one formula between the general value of 1st Jan. 20000 and 31st Dec. 2020, then change the format of the cell to be date
General number of 1st Jan 2000 is 36526 and of 31st Dec 2020 is 44196
So the formula would be :
=RANDBETWEEN(36256,44196) now the format cell to be changed date
Thanks
Maki S. Hussain
Baghdad-Iraq
This is exactly what came in my mind as alternative idea.👍
Ur actually the goat sir you just blessed me! Saved my project.
Thank you kind sir
Thank you
GOOD VIDEO, LIKES !!! :)
I find doing a randbetween the start date as general and end date as general then formatting as a date
Once you understand the date serial numbers for Excel, that is for sure a great tip! Thanks for sharing :)
This is great for building test data sets!@
Couldn't agree more :)
How can I divided date in series between 1 to 3100 bill no.only month of march2022.
Please do a video to do a random letters say between A and F. I want to group my group members into groups A to F. Thanks
This will help you: ua-cam.com/video/WXDUPjYqxdU/v-deo.html
Use RANDBETWEEN() with CHOOSE()
Super
How can I freeze the random sample once its been created?
copy and paste values would help
Good thx
More chance of March 1 and March 2 being selected than other dates.
I'm sure you could make a more advanced formula or a spreadsheet setup that would account for that issue - I have made large templates for this in the past - but I've found quick formulas like this are ok for many scenarios.