format(range("D1"),"dddd")


--
Kind Regards,

Niek Otten

Microsoft MVP - Excel
"marko" <no@email wrote in message
...
Is there an easier way of getting the weekday from a serial than
WeekdayName(Weekday(R1C4))? It seems a bit long winded but there doesnt
seem to be another function.