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.

What is Amazon Go and will it come to the UK? The store without checkouts or queues

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

Why ecommerce hasn't taken off on social media

New MacBook Pro 2016 review | MacBook Pro with Touch Bar review: Apple's expensive and powerful…