Nice, that would work just as well too!

Thank you everyone!


"Bernd P" wrote in message
...
Hello Robert,

Via VBA you can use
Format(n,"ddd")
or
Application.Worksheetfunction.Text(n,"ddd")
where n is your number 1, 2, 3, ... (starting with 1 = Sunday)