XL - show weekday

  mythras 22:24 22 Feb 04
Locked

I have the date shown in column B and wish to show the weekday in column A. Suggested formulae in XP give only the numeric values 1 to 7.

How can I convert this to show text entries as "Monday" "Tuesday" etc.?

Thanks in advance.

Mythras

  Paranoid Android 22:41 22 Feb 04

Format the column as Custom dddd and the display will change from 1 to Monday

Marvin

  pc moron 22:43 22 Feb 04

Or you can use =TEXT(WEEKDAY(B1),"dddd") in column A.

  mythras 09:30 23 Feb 04

Thanks all - both work well.

This thread is now locked and can not be replied to.

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Best Design, Illustration, Animation and VFX Awards of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced