Quick Excel Question

[Urban Ranger]

Is there any function that returns the name of weekdays (Monday, Sunday, etc.)?

If not, how do I do a lookup based on some calculations? Suppose I have a column containing the names of weekdays. Now when some calculations returns the number "3" how do I lookup Wednesday from that?

TIA

[Kuciwalker]

=INDIRECT(ADDRESS(ROW_NUM,COL_NUM))

[Urban Ranger]

Thanks K

[Asher]

You should use OpenOffice. Traitor.

[Hot Mustard]

Assuming cell A1 is "Nov-29-2005",

=WEEKDAY(A1)
will the day-of-week value of 3

=TEXT(WEEKDAY(A1), "dddd")
will return "Tuesday"

Edit: Oh, and I agree with Asher - OpenOffice rocks.

Edit2: It's the same in OpenOffice, except that function parameters are separated by semi-colons. (i.e. =TEXT(WEEKDAY(A1); "dddd") )

[Asher]

I think OpenOffice is a steaming pile of horse dung best used by people who don't need to interoperate with real people and businesses.

I'm mocking UR for using MS Office when he tells everyone else to use OpenOffice.

[Hot Mustard]

Originally posted by Asher
I think OpenOffice is a steaming pile of horse dung best used by people who don't need to interoperate with real people and businesses.

I'm mocking UR for using MS Office when he tells everyone else to use OpenOffice.

I know.

[Urban Ranger]

Originally posted by Asher
I think OpenOffice is a steaming pile of horse dung best used by people who don't need to interoperate with real people and businesses.

Such an opinion is strange, seeing how it came from somebody who had no real working experience.

Originally posted by Asher
I'm mocking UR for using MS Office when he tells everyone else to use OpenOffice.

Clown.

That's not for me, that's a question from somebody else.

[Asher]

Only someone clueless would call me a clown!