Weekday shown as text for clarity

  • Thread starter Thread starter paulmoles
  • Start date Start date
P

paulmoles

How can I get the Weekday function to display a text
result, ie Sunday, Monday, Tuesday etc dependent upon
referenced cell date. I can get 1,2,3,4,5,6,7 but want to
display a legible day. I currently use a VLOOKUP table
from a hidden sheet, surely it can be done in cell.
NB (I don't use the information in further calculation)

example of current use.
=VLOOKUP(WEEKDAY(E8,1),Sheet2!C5:D11,2)
 
Hi

You could just format your cell as dddd. Another way is to use
=TEXT(A2,"dddd") in an adjacent cell.
 
Thanks for that sometimes the simplest things are the
hardest to find.

Thanks
Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

can lookup return cell reference istead of "text" for sumif? 1
using conditional criteria for weekdays 1
Execute a FIND on formula results 4
Difficult Formula 9
can lookup return cell reference istead of "text" for sumif? 4
#Value in random cells 3
Date criteria for autofilling date on a form 3
Nested if, sum & vlookup Function 4

Back
Top