XL - show weekday

  mythras 22:24 22 Feb 2004
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 2004

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

Marvin

  pc moron 22:43 22 Feb 2004

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

  mythras 09:30 23 Feb 2004

Thanks all - both work well.

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

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?