I have this formula

Worksheets("Master (2)").Name = Worksheets("Master (2)").Range("month").value

the result is 38838 which is the numerical value of the date - what I need
is the either mmm-yy value of the Range("month").value

in other words, I would like the worksheetname to be: May or May 06

can anyone help?