The general formula is given by:
RANDBETWEEN(A,B)
For a single die, and A = 1 and B = 6. The correct Excel expression is given by:
RANDBETWEEN(1,6)