How to display birth dates between Jan. 1 1994 and Dec. 31,1994 in a way that there is a 65% chance that someone was born in 1994?
How to display birth dates between Jan. 1 1994 and Dec. 31,1994 in a way that there is a 65% chance that someone was born in 1994?
Surely if you're displaying DOBs in 1994 then there's a 100% chance all of them are in 1994?
Could you explain a little more what your need here?
BSB
Sorry I meant Jan. 1 1992*
Try this ...
=IF(RANDBETWEEN(1,100)<=65,RANDBETWEEN(DATE(2014,1,1),DATE(2014,12,31)),RANDBETWEEN(DATE(2012,1,1),DATE(2013,12,31)))
Last edited by Phuocam; 03-03-2018 at 07:31 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks