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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

My Autofilter is overzealous! 1
Next weekday ... 3
Weekday() result differs from one computer to another ??? 4
Send data to serial port 3
Weekdays between two dates in Excel? 2
Turning off automatic calculation 0
Creating a printable raffle ticket with serial numbers 0
How to format cell to get first capital letter? 5

Top