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

iMac Pro review

Why this awful City of Los Angeles job ad for a graphic designer is actually brilliant

iMac Pro review

Les meilleures prises CPL (2018)