Can you get Excel to return the name of the Day when you give it a date?
Posted by Chris Rock on August 31, 2001 8:33 AM
I have a date, and I'd like Excel to tell me what day of the week it is, for example, if it's 8/31/01 it would tell me "Friday".
The WEEKDAY formula gives me a number, and I suppose I could reference a lookup table that matches these numbers to days of the week. But I'd like to avoid that if I can.
I doubt if this is possible without a custom VBA function or a Vlookup table, but if anyone knows how, it would be nice.