Hey!

How can I point a formula to read DAYS opposed to the underlying date/numbers?

e.g
Cell Contents = numeric, 42298
Formatted to appear as days (Mon, Tue, Wed, Thu, Fri, Sat, Sun)

When writing VLOOKUP, etc. I want to lookup the DAY (Mon, Tue, etc.) value.

Any ideas?