Randomize dates

[reellavkastning]

I want to randomize days in the month based upon having 31 days in some months and some others having 27 and 30....


=IF(OR(I2=1;3;5;7;8;10;12);RANDBETWEEN(1;31);IF(I2=2;RANDBETWEEN(1;27);RANDBETWEEN(1;30)))

 

[Ruddles]

=IF(OR(I2=1;[COLOR=red][B]I2=[/B][/COLOR]3;[B][COLOR=red]I2=[/COLOR][/B]5;[B][COLOR=red]I2=[/COLOR][/B]7;[B][COLOR=red]I2=[/COLOR][/B]8;[COLOR=red][B]I2=[/B][/COLOR]10;[B][COLOR=red]I2=[/COLOR][/B]12);RANDBETWEEN(1;31);IF(I2=2;RANDBETWEEN(1;27);RANDBETWEEN(1;30)))

Do you only have 27 days in February where you are?

 

[reellavkastning]

Ha,

A little typo. Well the problem is still the same...with 28 days in February.

 

[Ruddles]

My change didn't fix the formula?

 

[shg]

Another way:

=DAY(RANDBETWEEN(I2 - DAY(I2) + 1, EOMONTH(I2, 0)))