ExcelBanter - getting the Weekday from serial

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - getting the Weekday from serial (https://www.excelbanter.com/excel-programming/281487-getting-weekday-serial.html)

marko

getting the Weekday from serial

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

getting the Weekday from serial

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.

All times are GMT +1. The time now is 02:31 PM.