Function to display day in text format

W

Weasel

I need a formula that will display the day (i.e. Sunday, Monday, etc..
based on a date in another cell (i.e. B2). Thanks in advanc
 
B

Bob Phillips

=TEXT(B2,"dddd")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
J

John Michl

Two other methods...pick your preference.

Use custom formating (Format > Cells> Custom enter dddd in the custom
window

=CHOOSE(WEEKDAY(A1),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")

- John
 
Top