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.

Hands-on: Samsung Galaxy S8 review

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

Samsung's beautifully designed Galaxy S8 makes for better VR experiences too

47 iPhone camera tips to help you take better photos