getting the Weekday from serial

M

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.
 
N

Niek Otten

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


--
Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Top