Using/referencing custom lists
 

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.

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

"KR" wrote:

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.