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

--
The enclosed questions or comments are entirely mine and don't represent the
thoughts, views, or policy of my employer. Any errors or omissions are my
own.