I screwed up use
=38354+RANDBETWEEN(1,5)+7*RANDBETWEEN(0,30)
I meant to start with a sunday and I started with a friday.

the
"STEVEB" wrote:


dj,

Thanks for your help.

I am still getting Saturday & Sunday. Have I written the formula
correctly?

=38352+RANDBETWEEN(1,5)+7*RANDBETWEEN(0,30)

Thanks


--
STEVEB
------------------------------------------------------------------------
STEVEB's Profile: http://www.excelforum.com/member.php...fo&userid=1872
View this thread: http://www.excelforum.com/showthread...hreadid=389443