Using/referencing custom lists

[KR]

I recently helped a coworker who needed to translate dates into the days of
the week (from a concatenated string), so I used the weekday function to get
the numeric day of the week, then used a vlookup against a list of days to
get the name of the day of the week (e.g. 5= "Thursday")

1 Sunday
2 Monday
3 Tuesday
etc.

I already knew there were custom lists in excel, including the weekday
names, but I wasn't sure how to access them, if they can be accessed at all.
Is there a way to directly access a custom list and avoid a vlookup? I'm
just interested for future reference. I didn't see an array name associated
with custom lists, like "weekdaynames" where I could use
myday = weekdaynames(5) and have it evaluate as "Thursday", or any other
method to pull from my custom lists...

Thanks,
Keith

 

[Guest]

Hello KR,
If cell A1 has a date in it, in cell B1, to return the day of the week, you
can type

=TEXT(A1,"dddd")

Cheers,
Annie