Random Numbers between 0 and 31 in Excel 3

[qwasy]

hi guys - especially Zathras

(look at thread56-1281655 - 22 Sep 06)

I need to fill a column with random the numbers 0-31.

maestro Zathras wrote nice and short:

A1: =MID(W1,INT(RAND()*(11-ROW(W1)))+1,1)+0
W1: '0123456789
W2: =LEFT(W1,FIND(A1,W1)-1)&MID(W1,FIND(A1,W1)+1,99)

i tried to modify this solution (W1) for numbers 01 02 03 04 ..... 29 30 31 (days of month) - unsuccessfully

would you be or anybody so kind and help me ?

thanking you in advance

 

[qwasy]

SkipVought - how can i assign you another star ?

perfect solution :-D

 

[SkipVought]

Thanx for the thot!

Skip,
[sub]
When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen![/sub]

 

[Welshbird]

qwasy - you can't, but I agree with you so I will on your behalf.

Fee

The question should be [red]Is it worth trying to do?[/red] not [blue] Can it be done?[/blue]