getting the Weekday from serial

[marko]

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.

 

[Niek Otten]

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


--
Kind Regards,

Niek Otten

Microsoft MVP - Excel