Return random dates in a particular range

	A	B
1	15	6
2	=INT(RAND()*25)+1=15	=INT(RAND()*25)+1 = 5
3	=INT(RAND()*25)+1=6	=INT(RAND()*25)+1 = 23

Built-in Functions

INT - The number rounded down to the nearest integer.
RAND - The random number between zero and one (>=0 and <1).

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top