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
Format the column as Custom dddd and the display will change from 1 to MondayMarvin
Or you can use =TEXT(WEEKDAY(B1),"dddd") in column A.
Thanks all - both work well.
This thread is now locked and can not be replied to.
iMac Pro review
Why this awful City of Los Angeles job ad for a graphic designer is actually brilliant
Les meilleures prises CPL (2018)
© Copyright 2018 IDG UK. All Rights Reserved.